Concatenate Dates

[Toastis]

I can't seem to combine a week start date with a week ending date (hyphen separator - it doesn't record the numbers as dates.
Week Start Week End
1/1/2011 1/8/2011
=CONCATENATE(A2,"-",B2)

I get the following result:

40544-40551

Any thoughts?

 

[c_m_s_jr]

TEXT(A1,"mm/dd/yyyy")&"-"&TEXT(B2,"mm/dd/yyyy")

 

[Jonmo1]

Wrap the text function around the dates...

Try
=CONCATENATE(TEXT(A2,"M/D/YYYY"),"-",TEXT(B2,"M/D/YYYY"))


Side note, the & symbol does the same thing as concatenate...
=TEXT(A2,"M/D/YYYY") & "-" & TEXT(B2,"M/D/YYYY")


Hope that helps.

 

[Toastis]

Thank you very much - works like a charm!