Convert Numeric Format to a Date Format 2

[cghoga]

I have a formula in Excel that concatenates text with a date from another cell and the date is showing up as 39264 rather than July 1, 2007.

Is there a way within an Excel formula to get the desired format of July 1, 2007?

i.e. ...

Date Range of July 1, 2007 to July 31, 2007

Rather than...

Date Range of 39264 to ...

Thanks!

 

[AnotherHiggins]

="Date Range of " & Text(A1,"MMMM D, YYYY") & " to " & Text(B1,"MMMM D, YYYY")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[GlennUK]

="Date range of "&TEXT(cell_ref,"mmmm d, yyyy")&" to "&TEXT(cell_ref2,"mmmm d, yyyy")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

Darn it! Beaten by a minute this time!!!! :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[cghoga]

You guys are terrific! Thanks!