Hi
try
=TEXT(A1,"MM/DD/YY") & " - " & TEXT(B1,"MM/DD/YY")
--
Regards
Frank Kabel
Frankfurt, Germany
Lisa wrote:
I am trying to concantenate 2 dates field together like 1/1/04 &
12/31/04 into 1 field showing 1/1/04 - 12/31/04 but not able to use
the concatenate function for it convert to data to a number. Any help
is appreciated.
|