Excel Concatenate Dates Without Losing Their Format

Formulas & functions · Updated November 19, 2026

Excel does not preserve a date cell’s display format when you concatenate it: the date may appear as a serial number or an unexpected value. Wrap the date in TEXT first, as in =B2&TEXT(A2,"mmmm d, yyyy"), to turn it into a readable date string while joining it to other text.

Why a Concatenated Date Can Look Different

Excel stores dates as numbers, not as the formatted words and digits shown on the worksheet. A cell’s number format tells Excel how to display its date value—for example, as “Jul 4, 2026” or “7/4/2026.” The underlying value remains numeric, which lets Excel sort dates and use them in calculations.

Concatenation creates text. When Excel joins a date value to text, it does not automatically carry over the date cell’s number format. Instead, Excel converts the value to text using a general representation, which can look like a serial number. Applying a date format to the original cell does not change this behavior because that format controls the cell’s display, not the value used in the joined text.

The fix is to tell Excel how to render the date as text before joining it. The TEXT function takes a value and a format code, then returns text in that format. This distinction is useful: the result looks like a date, but it is text rather than a date value that Excel can directly use in date arithmetic.

The Quickest Formula for One Date

Suppose A2 contains a real Excel date and B2 contains a label such as “Due date: ”. In a different cell, enter the following formula:

With the date in A2 and the label in B2, use =B2&TEXT(A2,"mmmm d, yyyy"). If A2 is July 4, 2026 and B2 is “Due date: ”, the result is Due date: July 4, 2026.

The ampersand joins the label and the formatted date. You can put text directly in the formula too. For example, if A2 contains the date, use = "Due date: "&TEXT(A2,"mmmm d, yyyy")—without the space after the equals sign if you prefer. The formula is valid either way. The result is the same label and date, with the month written out and a four-digit year.

To build the formula in Microsoft 365 for Windows, select the result cell, type an equals sign, select or type the label cell, enter &, and then add TEXT around the date reference. Press Enter. Excel for Mac and Excel for the web use the same formula. Depending on your regional settings, Excel may require semicolons instead of commas between function arguments; use the separator Excel accepts in your installation.

Choose a Date Format That Fits the Sentence

The second argument in TEXT is a format code in quotation marks. Choose a code based on the audience and where the result will be used. Common options include:

  • "mmm d, yyyy" displays Jul 4, 2026.
  • "mmmm d, yyyy" displays July 4, 2026.
  • "mm/dd/yyyy" displays 07/04/2026.
  • "d-mmm-yyyy" displays 4-Jul-2026.
  • "dddd, mmmm d, yyyy" displays Saturday, July 4, 2026.

For example, with a date in A2, =TEXT(A2,"dddd, mmmm d, yyyy") returns the weekday and full date as text. That can be useful in a sentence or report heading. If you are joining dates for readers in different regions, spell out the month or use a month name with the day; a numeric date such as 04/07/2026 can mean April 7 or July 4 depending on local convention.

To include a time, put time codes in the same format string. With a date and time in A2, =TEXT(A2,"mmm d, yyyy h:mm AM/PM") displays a result such as Jul 4, 2026 3:30 PM. If the source includes a time but your format code includes only a date, the time is omitted from the displayed text. The source value has not been changed.

Join Several Dates or Add Text Around Them

Each date needs its own TEXT conversion when you join multiple date cells. For example, assume A2, A3, and A4 contain three dates. To display them as a comma-separated list with abbreviated months, enter:

With dates in A2:A4, use =TEXTJOIN(", ",TRUE,TEXT(A2,"mmm d"),TEXT(A3,"mmm d"),TEXT(A4,"mmm d")). If the cells contain July 4, July 5, and July 6, the result is Jul 4, Jul 5, Jul 6.

Here, TEXT formats each date, while TEXTJOIN inserts the comma and space between the resulting text values. This example uses individually specified cells, so it does not depend on Excel interpreting an array of dates inside TEXT. For a short label around one date, put the date conversion between text pieces: with the date in A2, ="Report for "&TEXT(A2,"mmmm yyyy")&" results" returns “Report for July 2026 results.”

Be deliberate about spaces and punctuation. A space inside a quoted text piece is part of the output; a missing space can make the words run together. Likewise, use a date format with a year if the text might be read without its surrounding context.

Does CONCATENATE or CONCAT Keep the Date Format?

No. Changing the joining function does not solve the formatting issue. The older CONCATENATE function, the newer CONCAT function, and the ampersand operator all join values as text; none automatically imports the source cell’s visible number format. Format the date with TEXT first, regardless of which joining method you choose.

With a label in B2 and a date in A2, =CONCAT(B2,TEXT(A2,"mmm d, yyyy")) produces the label followed by a formatted date. In current Microsoft 365 versions, CONCAT is available, but the ampersand is often the simplest choice for a short formula and works in older Excel versions as well. TEXTJOIN is convenient when you need a repeated delimiter between several pieces. Pick the function for the joining task, then use TEXT wherever a number or date needs a deliberate display format.

Common Problems and How to Fix Them

  • The result is still a serial number. Check that TEXT surrounds the date reference, and that its format code is in quotation marks. Formatting the result cell as a date will not fix a string created by concatenation.
  • The result shows an unexpected date or an error. Confirm that the source is a real date value, not text that merely looks like one. A date stored as text may need to be converted before Excel can format it reliably. Check the source cell and how the date was imported or entered.
  • The month and day appear reversed. The formula’s format code determines the order. Use a spelled-out month, such as "mmmm d, yyyy", to reduce ambiguity for readers using different regional conventions.
  • The output has no spaces. Add spaces inside the quoted labels or delimiters. Excel does not insert spaces automatically between joined values.
  • A time disappears. Include time codes such as h:mm AM/PM in the TEXT format if you need it displayed. A date-only format intentionally leaves the time out of the text.
  • The date changes after editing the source. That is expected: a formula recalculates when its referenced date changes. If you need a fixed snapshot, copy the result and use Paste Special > Values. The pasted result remains text.

When a formula is rejected, also check argument separators. The examples here use commas, as in typical English-language Excel settings, but installations configured for some regions use semicolons. Follow the separator Excel inserts or accepts when you enter a function.

Keep a Real Date for Calculations

A formatted concatenation is best for a message, a label, or a line of text—not as a replacement for the original date. Since TEXT returns text, a result such as “July 4, 2026” is not equivalent to a date value for sorting, date subtraction, or date-based calculations. Keep the original date in its own cell whenever the workbook needs to calculate with it.

A useful layout is to preserve the date column as real dates and create a separate display or description column with the concatenation formula. You can also format the original date cell directly when you only need its appearance to change. Select the date cell, open Format Cells with Ctrl+1 on Windows, and choose a date format or a custom format. On Mac, use Command+1 to open Format Cells. This changes how the date is displayed without converting it to text.

If a combined text result must be sent to another system, check that system’s requirements. Some imports expect a specific text date pattern; others need a genuine date field. A text string that looks clear to a person may not be recognized as a date by another application. Keeping a separate original date column makes it easier to export the right type of value.

Frequently Asked Questions

Can I concatenate a date and keep the cell’s existing format automatically?
No. Excel does not carry the source cell’s number format into concatenated text. Use TEXT with the display format you want, then join its result to the other text.

Why does Excel show a number when I join a date to a name?
The date is stored as a numeric value, and concatenation converts the value rather than copying the cell’s visual formatting. Wrapping the date reference in TEXT gives Excel an explicit date format to use in the result.

Does changing the format of the formula cell fix the result?
Usually not. Once the formula has combined the date into a text string, a date number format cannot reinterpret the date portion inside that string. Format the date with TEXT in the formula instead.

Can I use TEXT with CONCAT or TEXTJOIN?
Yes. Format each date with TEXT, then pass those text results to the joining function. CONCAT and TEXTJOIN determine how pieces are joined; they do not decide how a date should appear.

Will the concatenated result still work in date calculations?
No, not as a date value. The formatted output from TEXT is text. Keep the original date in a separate cell for sorting, comparisons, and calculations, and use the joined text only where a readable string is needed.

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.