Concatenation using dates

[Guest]

I am trying to merge a few cells together, using Concatenation some of which
contain dates, when the cells get merged together it converts the date back
to the orginal number that windows stores dates as, is their a way to retain
the format as a date in this new merged cell?

 

[Guest]

Try something like this:

With
A1: "The date "
B1: 01/29/2007
C1: " is a "

Then
D1: =A1&TEXT(B1,"MM/DD/YYYY")&C1&TEXT(B1,"DDDD")

returns: The date 01/29/2007 is a Monday

Does that help?
***********
Regards,
Ron

XL2002, WinXP