cell, which should display for ex: Jan 1 To Jan 5.

  • Thread starter Thread starter navin
  • Start date Start date
N

navin

Hi,

I have a cell, which should display for ex: Jan 1 To Jan 5. I am
confused, as how to incorporate this both the text and the day of the
date in the above format.


Please help.

Regards,
Navin
 
Put a date in A1, and then try this:

=TEXT(A1,"mmm d")&" To "&TEXT(A1+4,"mmm d")
 
Or:

=TEXT(A1,"mmm d")&" To "&TEXT(A2,"mmm d")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Assuming your dates are in A1 and A2..........put this in A3, or wherever....
|
| =TEXT(A1,"mmm")&DAY(A1)&" to "&TEXT(A2,"mmm")&DAY(A2)
|
| Vaya con Dios,
| Chuck, CABGx3
|
|
|
| "navin" wrote:
|
| > Hi,
| >
| > I have a cell, which should display for ex: Jan 1 To Jan 5. I am
| > confused, as how to incorporate this both the text and the day of the
| > date in the above format.
| >
| >
| > Please help.
| >
| > Regards,
| > Navin
| >
| >
 
Thank you very much for this. However, i was wondering if the same
thing somehow can be used to get display in the title of the chart.

Sorry for being so greedy :-)

Thanks again for the help.

Regards,
Navin
 
Select the Chart or Chart Sheet.

Click on Title box and in the formula bar type the formula given.

Or ="Number of Widgets Sold "&TEXT(A1,"mmm d")&" To "&TEXT(A2,"mmm d")


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top