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

[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

 

[RagDyer]

Put a date in A1, and then try this:

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

 

[Niek Otten]

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
| >
| >

 

[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

 

[Gord Dibben]

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