Concatenate Dates

[Corticus]

Is there any way to concatenate dates and maintain the date property?

Right now I have:

="From "&I6&" through "&K6
which gives me:
From 37316 through 37346

Thanks
Corticus

 

[Asala42]

Hey

Use the TEXT formula:

=TEXT(K6,"mm/dd/yy")&" through "&TEXT(I6,"mm/dd/yy")

Adam

 

[IML]

you can use
"From "&text(I6,"mm-dd-yy")&" through "&text(K6,"mm-dd-yy")

an adjust mm-dd-yy to suit.

 

[Corticus]

Thanks for the replies,
Worked Great!!!

You guys rock!

Corticus