How to CONCATENATE two dates field together

[Lisa]

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.

 

[Frank Kabel]

Hi
try
=TEXT(A1,"MM/DD/YY") & " - " & TEXT(B1,"MM/DD/YY")

 

[tjtjjtjt]

Lisa,

The two dates are in A7 and A8 for this example:
=TEXT(A7,"m/d/yyyy")&" - "&TEXT(A8,"m/d/yyyy")

tj

 

[Jason Morin]

Try:

=TEXT(A1,"mm/dd/yy")&" - "&TEXT(B1,"mm/dd/yy")

HTH
Jason
Atlanta, GA

 

[JE McGimpsey]

one way:

=TEXT(A1,"m/d/yy") & TEXT(B1,"m/d/y")

 

[JE McGimpsey]

Whoops, try

=TEXT(A1,"m/d/y - ")&TEXT(B1,"m/d/y")