Excel Concatenate Dates While Keeping Formatting in Text

Formulas & functions · Updated November 19, 2026

To concatenate a date in Excel and keep its display format, convert the date to formatted text with TEXT before joining it to other text. With a date in A2, for example, use ="Due: " & TEXT(A2,"mmmm d, yyyy"); if A2 contains January 5, 2026, the result is Due: January 5, 2026.

Why a concatenated date can look different

Excel stores dates as serial numbers, not as the words and punctuation you see in a cell. A cell’s number format tells Excel how to display that underlying value: one date might appear as 1/5/2026, January 5, 2026, or 5-Jan-26, even though the stored date is the same. When a formula joins a date to text, Excel converts the date value to text, and the cell’s original number format is not carried into that text.

This is why a formula such as =A2&" is the deadline" may show a number followed by the label rather than a readable date. Changing the format of the formula cell to Date does not solve the problem: the formula’s result is text, not a date serial that a date format can display. Use TEXT to specify the date’s appearance as part of the formula.

The basic formula using TEXT

Put the date in one cell, then wrap that cell reference in TEXT(value, format_text). The first argument is the value to display; the second is a format code in quotation marks. Join the formatted result to labels or other values with the ampersand operator (&).

With the date in A2, use ="Due: " & TEXT(A2,"mmmm d, yyyy"). If A2 is January 5, 2026, the result is Due: January 5, 2026. If you want a shorter date, with the same cell layout use ="Due: " & TEXT(A2,"m/d/yy"), which returns Due: 1/5/26. The source date remains unchanged in A2.

For a date in A2 and a description in B2, use =B2 & " — " & TEXT(A2,"mmm d, yyyy"). If B2 contains Invoice and A2 contains January 5, 2026, the result is Invoice — Jan 5, 2026. The spaces around the separator are included in the quoted text, so the output reads naturally.

Choose a format code that matches the desired output

The format code inside TEXT determines what readers see. Common date components include d for the day number, dd for a two-digit day, ddd for an abbreviated weekday, and dddd for the full weekday name. For months, m or mm gives a number, while mmm and mmmm give abbreviated and full month names. Use yy for a two-digit year and yyyy for a four-digit year.

With January 5, 2026 in A2, =TEXT(A2,"dddd, mmmm d, yyyy") returns Monday, January 5, 2026. With the same cell layout, =TEXT(A2,"mmm d, yyyy") returns Jan 5, 2026. These examples produce text, so choose a format that is clear in the sentence or report where the result will appear. A two-digit year is compact but can be less clear in records that need to remain understandable over time.

To include a fixed label, place it outside the date format code and join it separately. That is often easier to read and maintain than trying to place sentence text inside a number format. In date-time formats, the letter m can mean either month or minute depending on its position: near hour and second codes it represents minutes. If a time display looks wrong, check the placement of h, m, and s.

Combine dates with multiple cells or labels

The ampersand operator works for two pieces or many. For example, with a first name in A2, a date in B2, and a location in C2, use =A2 & " — " & TEXT(B2,"mmmm d, yyyy") & " — " & C2. If the cells contain Maya, January 5, 2026, and Toronto, the result is Maya — January 5, 2026 — Toronto. Each separator is ordinary text and can be changed to a comma, colon, or other wording.

In Microsoft 365, TEXTJOIN can be convenient when you need one delimiter between several items. With a date in A2 and a description in B2, use =TEXTJOIN(" — ",TRUE,B2,TEXT(A2,"mmm d, yyyy")). If B2 contains Invoice and A2 is January 5, 2026, it returns Invoice — Jan 5, 2026. The TRUE argument tells the function to ignore empty items; it does not remove the delimiter inside a nonempty item. For a small number of parts, ampersands are often more straightforward.

Include times and date ranges

A date-time value contains both a date and a fraction representing time. If you concatenate it using only a date format, the time will not appear. Specify both parts in the TEXT format code. With a date and time in A2, use =TEXT(A2,"mmm d, yyyy h:mm AM/PM"). If A2 contains January 5, 2026 at 2:30 PM, the result is Jan 5, 2026 2:30 PM. A 24-hour style can be written as yyyy-mm-dd hh:mm.

To make a date range, format both date cells independently. With the start date in A2 and end date in B2, use =TEXT(A2,"mmm d") & "–" & TEXT(B2,"mmm d, yyyy"). If A2 is January 5, 2026 and B2 is January 9, 2026, the output is Jan 5–Jan 9, 2026. This abbreviated style works well when both dates are in the same year; for ranges across years, include the year on each side so the meaning is unambiguous.

Regional settings and common formula problems

Date formats can appear differently across regional settings. For example, a numeric date such as 1/5/2026 can be read as January 5 or May 1 depending on the workbook’s date interpretation. A format such as mmmm d, yyyy makes the output easier to read, but it does not repair a source date that Excel interpreted incorrectly. Check the original cell and confirm that it represents the intended date before building a text string.

  • The result shows a number: the formula may be joining the raw date instead of wrapping the cell reference in TEXT. Check that the date appears inside the first argument of TEXT.
  • The result displays a formula error: check quotation marks, parentheses, and separators. Excel installations using a regional list separator may require semicolons instead of commas in formulas; the examples here use commas.
  • The month or minute looks wrong: review the placement of m in date-time format codes. Excel interprets it as minutes in time contexts.
  • The output has unexpected spaces: inspect the literal text between ampersands. Spaces inside quotation marks are part of the result; spaces in the source cells are retained too.

Formatting tokens and names can also be affected by Excel’s language and regional settings. If a formula is shared with people using other locales, test the display in the target environment. For reports that require a specific language or a standard machine-readable date, consider whether a fixed numeric pattern such as year-month-day is more suitable than a month name.

Keep the result usable as a date

A joined result is text. It may look like a date, but Excel will not treat the whole string, such as “Due: January 5, 2026,” as a date for date arithmetic, date filtering, or a true chronological sort. This is an important distinction: TEXT preserves the date’s appearance in the string, not the date’s underlying numeric behavior.

When you still need calculations, keep the original date in its own column and use a separate formula column for the display sentence. Calculate elapsed days, compare deadlines, or sort records using the original date column. The formatted text column is best for labels, messages, exports, and presentation. If you only want a date to look different in a cell, change the cell’s number format instead of concatenating it; that keeps the stored value numeric.

If you need to send or archive the displayed wording without formulas changing later, copy the result and use Paste Special > Values. That replaces the formula with its current text result. It will no longer update when the source date or label changes, so retain the source cells or a backup if you may need to revise the output.

Frequently Asked Questions

Can I concatenate a date without using TEXT?
Yes, but Excel may convert the date to its serial number or another display that does not match the source cell. Use TEXT whenever the joined text must show a chosen date format.

Will formatting the formula cell keep the date format?
No. A cell number format affects numeric values, while a concatenation formula returns text. Set the appearance inside the formula with TEXT.

Can I keep the concatenated result as a real date?
Not if the result includes labels or separators; that combined string is text. Keep the real date in a separate cell for calculations and use a second cell to show the formatted sentence.

Why does Excel show a serial number after I join a date?
Excel stores dates as numbers, and concatenation can expose that stored value rather than the cell’s visual format. Wrap the date reference in TEXT and provide the desired format code.

Can I concatenate a date and time together?
Yes. Use a format code containing both date and time parts, such as mmm d, yyyy h:mm AM/PM, inside TEXT. Confirm that the source cell actually contains a time as well as a date.

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.