Concatinating two dates.....?

[Kelvin Beaton]

I have two cells that display dates. 1/25/2004 (B16) and 2/7/2004 (N22).
I want to combine the values in one cell formatted like this, "1/25/2004 -
2/7/2004".

This formula "=B16&" - "&N22" returns "38011 - 38024"

What's the answer? What am I missing?

Thanks

Kelvin

 

[Frank Kabel]

Hi
try
=TEXT(B16,"MM/DD/YYYY") & " - " & TEXT(N22,"MM/DD/YYYY")

 

[nitzsche]

You need something like =TEXT(A4,"m/d/yy")&" - "&TEXT(B4,"m/d/yy")

 

[Kelvin Beaton]

Thanks that worked great!!!

Hi
try
=TEXT(B16,"MM/DD/YYYY") & " - " & TEXT(N22,"MM/DD/YYYY")

 

[Kelvin Beaton]

Thanks for the great answer!

Kelvin