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