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.

Concatenating two date fields in Excel

Instead of using the function, you can use the ampersand (&) symbol to join the two date fields together. Here's how you can do it:

1. Select the cell where you want to display the concatenated date range.
2. Type in the formula
   Code:

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

   , where A1 and B1 are the cells containing the two dates you want to concatenate.
3. Press Enter to apply the formula.

This formula uses the function to format the dates as text, and then joins them together with the ampersand symbol and a hyphen (-) in between.

For example, if cell A1 contains the date 1/1/04 and cell B1 contains the date 12/31/04, the formula would look like this: . The result would be "1/1/04 - 12/31/04".

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.

Lisa,

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

tj

"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.

Try:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

one way:

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

In article ,
"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.

Whoops, try

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

In article ,
JE McGimpsey wrote:

one way:

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