Concatenate 2 Dates in Excel: Formulas and Formatting

Formulas & functions · Updated November 19, 2026

To concatenate two dates in Excel, convert each date to readable text with TEXT, then join the results with the ampersand operator. If the dates are in A2 and B2, use =TEXT(A2,"mmm d, yyyy")&" to "&TEXT(B2,"mmm d, yyyy"); for January 5 and January 12, 2026, the result is Jan 5, 2026 to Jan 12, 2026.

The quickest formula for joining two dates

In Microsoft Excel for Microsoft 365 on Windows, the ampersand (&) is a straightforward way to combine date text with a separator. The formula above does three things: it formats the value in A2, inserts the words “to,” and formats the value in B2. The result is one text string in a single cell, suitable for a label, report heading, or message.

To try it, enter two real Excel dates in A2 and B2, then enter the formula in C2. For example, if A2 contains January 5, 2026 and B2 contains January 12, 2026, C2 displays “Jan 5, 2026 to Jan 12, 2026.” The date values in A2 and B2 are not changed; the formula creates a separate text result.

  1. Put the first date in A2 and the second date in B2.
  2. Select the cell where you want the combined result, such as C2.
  3. Enter the formula and press Enter.
  4. If you have more rows, drag the fill handle from C2 down to copy the formula to them.

The same formula works in Excel for Mac and Excel for the web. The ribbon layout can vary slightly between platforms, but this formula does not depend on a particular ribbon command.

Why dates need formatting before you concatenate them

Excel generally stores a date as a number, often called a serial value, and applies a number format to display that value as a calendar date. The cell may show “Jan 5, 2026,” while its underlying value is numeric. When you join that value directly to other text, Excel may show the number instead of the familiar date display. That is why the TEXT function is important: it turns the date value into text in the format you choose.

For example, formatting A2 as “January 5, 2026” with the Home tab changes how A2 appears, but it does not turn the underlying value into text. A formula that combines A2 with a word can still produce a serial number. Applying a cell format to the formula result does not reliably solve that problem either, because the combined result is text, not a date value. Format each date inside the formula before joining it.

This distinction is useful beyond date ranges. Any time a date is part of a sentence, filename, status label, or report title, decide how it should read and format it explicitly. The source cells can retain their real date values for sorting, filtering, and date calculations, while the formula cell provides a readable presentation.

Choose a date format and separator

The format code inside TEXT controls how each date appears. In the main example, mmm gives an abbreviated month name, d gives the day without a leading zero, and yyyy gives a four-digit year. You can change the format to suit your audience, document, or naming convention.

  • Compact: “1/5/2026 to 1/12/2026” is short, but numeric dates can be interpreted differently in different regions.
  • Readable: “Jan 5, 2026 to Jan 12, 2026” is relatively concise and makes the month clear.
  • Formal: “January 5, 2026 through January 12, 2026” spells out the month and uses a more formal separator.
  • Sortable: “2026-01-05 to 2026-01-12” puts the year first and is often convenient in filenames or data exports.

For the sortable style, with the first date in A2 and the second in B2, enter =TEXT(A2,"yyyy-mm-dd")&" to "&TEXT(B2,"yyyy-mm-dd"). With the example dates, it returns “2026-01-05 to 2026-01-12.” The year-month-day order avoids ambiguity between common month-first and day-first formats, although the output is still text.

For a longer month name, with dates in A2 and B2, use =TEXT(A2,"mmmm d, yyyy")&" through "&TEXT(B2,"mmmm d, yyyy"). For January 5 and January 12, 2026, the result is “January 5, 2026 through January 12, 2026.” You can replace the separator inside the quotation marks with a hyphen, an en dash, a slash, or plain wording. Keep the separator quoted so Excel treats it as literal text.

Use ampersand, CONCAT, or TEXTJOIN

The ampersand operator is often easiest for a short expression because the order of the pieces is visible. Excel also provides CONCAT, which joins text arguments. If A2 and B2 contain the two dates, this alternative is =CONCAT(TEXT(A2,"mmm d, yyyy")," to ",TEXT(B2,"mmm d, yyyy")). It returns the same readable range as the ampersand formula.

For two dates, CONCAT is mostly a matter of preference; it does not remove the need to use TEXT. Both approaches need each date converted into the intended text format first. The older CONCATENATE function is also present in Excel for compatibility, but it is not necessary for this task. An ampersand formula is generally compact and easy to edit.

TEXTJOIN can be useful when a formula needs a delimiter and several text items, but it is more than most two-date ranges require. Whichever joining method you choose, the key idea remains the same: format the dates as text, then add the separator and any surrounding words. Do not expect a joining function by itself to preserve the dates’ visual number formats.

Add labels, words, or a date range description

You can put explanatory text before or after the dates, which is helpful when the result will be read outside the spreadsheet. With the start date in A2 and end date in B2, use ="Event dates: "&TEXT(A2,"mmm d, yyyy")&" to "&TEXT(B2,"mmm d, yyyy"). If the dates are January 5 and January 12, 2026, the cell displays “Event dates: Jan 5, 2026 to Jan 12, 2026.” The label is just another text segment in the expression.

For one date followed by a description, with the date in A2 and an event name in B2, use =TEXT(A2,"mmmm d, yyyy")&" - "&B2. If A2 holds January 5, 2026 and B2 contains “Registration opens,” the result is “January 5, 2026 – Registration opens.” This pattern is useful for reminders, invoices, schedules, and report headings. Make sure the text cells do not contain unwanted leading or trailing spaces, or those spaces will also appear in the result.

If you copy the formula down a table, relative references such as A2 and B2 adjust automatically to A3 and B3, and then to later rows. If one date should remain fixed while the other changes, use an absolute reference for that cell. For example, pressing F4 while editing a cell reference in Excel for Windows cycles through reference styles; on Mac, the shortcut can depend on the keyboard and system settings. You can also type the dollar signs directly, such as $A$2, when appropriate.

Common problems and how to fix them

  • A long number appears instead of a date. The formula is joining the underlying numeric value. Wrap the date reference in TEXT and supply the format code you want.
  • The result shows an unexpected month or day. Check both the stored date and the format code. In Excel date formats, m represents a month in a date context, while mmm displays its abbreviated name. The value itself might also have been interpreted according to regional date-entry settings.
  • The result is not changing after you edit a source date. Confirm that the result cell contains a formula rather than pasted text, and check that calculation is set to Automatic under Formulas > Calculation Options.
  • A formula error appears. Check that each opening parenthesis has a closing one, every text segment has straight quotation marks, and the cell references are valid. If the formula was copied from a formatted document, replace curly quotation marks with straight ones.
  • There is an unwanted space or punctuation mark. Inspect the quoted separator and any text cells included in the formula. Spaces inside quotation marks are intentional; spaces at the edges of source text may not be.

One frequent misconception is that a cell’s visible number format automatically travels into a concatenated result. It does not: the combined output is text, and Excel does not carry over the source cells’ display settings as part of that text. Another issue is regional date interpretation. “1/5/2026” can be read differently depending on regional conventions, so use an unambiguous input method or verify the date in the formula bar before creating a shared report.

When a formula is not the right output

Concatenating dates is useful when you need one readable label, but it changes the kind of result you have: the combined cell is text, not a date range that Excel can calculate with as a single date value. Keep the original start and end dates in separate cells if you need to sort by them, calculate the number of days between them, or filter using date criteria. Use the concatenated cell for display, and use the original date columns for analysis.

If you only need to show a date differently in its own cell, use a date number format instead of concatenation. Select the date cell, open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, then select Date or Custom and set an appropriate format. On Mac, Command+1 opens Format Cells. This changes the display without converting the date into text, so the cell remains useful in date arithmetic. It does not, however, combine two dates into one label.

If the combined text must be delivered as a fixed value, copy the formula result and use Paste Special > Values where available. This replaces the formula with its current displayed text, so later changes to the source dates will no longer update it. Keep a copy of the original formula or source data if you might need to revise the result later.

Frequently Asked Questions

Can I concatenate two dates without using TEXT?
It is possible to join date cells directly, but Excel may show their serial numbers rather than readable dates. Use TEXT around each date when you want a specific date appearance.

Can I use a hyphen or en dash between the dates?
Yes. Put the separator in quotation marks in the formula, for example “ – ” or “ – ”. The spaces are optional and determine how the final label looks.

Does concatenating dates change the original dates?
No. The source cells remain date values. The formula produces a separate text string, so calculations should continue to use the original cells.

Why does the formula return a number instead of a date?
Excel is exposing the date’s underlying numeric value during the join. Apply a format with TEXT to each date reference before combining them.

Can I combine dates and times this way?
Yes. Use TEXT with a date-and-time format, such as "mmm d, yyyy h:mm AM/PM", for each cell that contains a date and time. Check that the source cells actually contain time values as well as dates; otherwise, the time portion may display as midnight.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.