Concatenate Dates

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hello I have dates in columns A & B. Basically it is
a "From" & "To" date.

I tried to concatenate the dates on column C however it
gives me the numeric version (ex. 38059) when it is
concatenated.

How do I do make it so it looks like this (01/01/04 -
03/01/04)?

Right now it looks like this (37987 - 38047)

Help plz
 
Back
Top