Dates format when using "&"

[keith]

Does anyone know how to make dates resolve into a date format not a number when using a "&" ?

Example: y2 and z2 contain dates. I want to display those values combined into 1 cell seperated by a dash.

Formula is: =y2&" - "&z2

result is "37337 - 37377" but I need result to be "3/22/2002 - 5/1/2002"

Thanks in advance..

 

[BabyTiger]

Hi,

You might want to try the following formula:

=text(y2,"dd/mm/yyyy")&" - "&text(z2,"dd/mm/yyyy")

HTH

 

[kwaring]

I used this formula recently:

Make 2 supplementary cells with formulas like this:
=TEXT(Y2,"mmddyyyy")
=TEXT(Z2,"mmddyyyy")

And then just concatenate like u did already.
Hope that helps!
Kyle

 

[keith]

worked perfect - thanks..