Date Question - 12/1/2007 & "through" & 12/31/2007

[Guest]

Guru's,

I am racking my brain again with another date related issue. Hoping you can
smack some sense into me. )

My worksheet data looks like this: (comma seperated)

Start Date,End Date,Message
12/1/2007,12/31/2007,=a2&" thru "&b2
1/1/2008,1/30/2008,=a3&" thru "&b3

The results in column c is as follows:

Message
39417 thru 39447
39448 thru 39477

.... and I would like it to be like this instead:

Message
12/1/2007 thru 12/31/2007
1/1/2008 thru 1/30/2008

Any help you can provide would be greatly appreciated.

Thanks in advance,

Scott

 

[Ron Coderre]

Try this:
=TEXT(A2,"MM/DD/YYYY")&" thru "&TEXT(B2,"MM/DD/YYYY")

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Guest]

AWESOME!!!

Thank you!

 

[Ron Coderre]

I'm glad I could help....Thanks for the feedback.

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)