To concatenate a date in Excel and keep it readable, convert the date to formatted text with TEXT first, then join it to the other text. For example, if A2 contains a date, use ="Due: "&TEXT(A2,"mmmm d, yyyy") to produce a label such as Due: May 6, 2026.
Why concatenated dates can look like numbers
Excel stores dates as serial numbers so it can calculate with them. A date cell’s number format tells Excel how to display that number: the underlying value remains numeric, even when the cell shows a date such as May 6, 2026. When a formula joins that value to text, Excel uses the underlying value rather than carrying over the cell’s display format. The result can therefore contain a number instead of a date that looks familiar.
This is not a problem with the date itself or with the cell’s date formatting. It is a difference between a numeric date value and a text result. A formula that combines text and a date returns text, and ordinary cell formatting cannot apply a date format to only the date portion inside that text. Use TEXT to specify how the date should appear before joining it.
For instance, a worksheet might show May 6, 2026 in A2 while storing its serial number. Joining A2 directly to a sentence can expose that serial number. Formatting A2 as a long date changes what appears in A2, but does not change what a concatenation formula reads from A2.
The basic formula with TEXT
In Microsoft Excel for Microsoft 365 on Windows, the ampersand is a straightforward way to join text and values. In the example below, A2 contains a valid Excel date. The formula returns Due: May 6, 2026 when A2 is May 6, 2026.
With the date in A2, enter:
="Due: "&TEXT(A2,"mmmm d, yyyy")
The first argument of TEXT is the value to convert; the second is the format code in quotation marks. The ampersand joins the fixed words to the formatted date. You can put the date first, add several text fragments, or join values from other cells. Keep spaces and punctuation inside the quoted text fragments so the output reads naturally.
Excel also has the CONCAT function. It joins text from multiple arguments or a range, but it does not automatically preserve a referenced date cell’s display format. Format the date inside the function just as you would with the ampersand.
With a date in A2, this version returns the same result:
=CONCAT("Due: ",TEXT(A2,"mmmm d, yyyy"))
Use whichever style is easier to read in your workbook. For a short formula, & is often convenient; for several separate arguments, CONCAT can make the pieces easier to identify.
Choose a date format code
The format code inside TEXT controls how the date appears in the concatenated result. Common codes include:
dshows the day without a leading zero;ddadds one, as in 6 or 06.mmmshows an abbreviated month, such as May;mmmmshows the full month name.mshows the month number without a leading zero;mmshows it with one.yyshows a two-digit year;yyyyshows a four-digit year.
Combine codes and literal separators to get a style suited to the audience. For example, dd/mm/yyyy gives a day-first numeric date, while mmm d, yyyy gives a compact month-name date. A code such as mmmm d omits the year, which may be suitable for a birthday greeting but can be ambiguous in records covering multiple years.
Use a month name when a numeric date could be read in different ways across regions. For example, 04/05/2026 can mean April 5 or May 4 depending on the date convention. A result such as Apr 5, 2026 makes the intended date clearer. Excel’s language and regional settings can affect the language and appearance of month names and separators, so check a sample on the computers or in the files where the result will be used.
Examples for labels, reports, and filenames
With a date in A2, the following formats suit different kinds of text. Each formula returns text, not a date value.
- Readable sentence: With A2 containing May 6, 2026, enter
="Report date: "&TEXT(A2,"mmmm d, yyyy"). The result is Report date: May 6, 2026. - Compact label: With A2 containing May 6, 2026, enter
="Week of "&TEXT(A2,"mmm d"). The result is Week of May 6. - Sortable-looking date text: With A2 containing May 6, 2026, enter
=TEXT(A2,"yyyy-mm-dd"). The result is 2026-05-06, a clear year-month-day representation often used in filenames and exports.
The last example may look like a date, but it is still text. That distinction matters if you later sort, filter, compare, or calculate with the result. A text string in year-month-day order is easy for people to scan and often sorts predictably as text when every value uses the same fixed-width pattern, but it does not replace a real date for date arithmetic.
Include times as well as dates
Excel stores date and time together as a number: the whole-number portion represents the date and the fractional portion represents the time of day. If you concatenate the value without formatting it, the result may not show the time in the intended way. Include both date and time codes in TEXT when both matter.
With a date and time in A2, such as May 6, 2026 at 2:30 PM, enter:
="Updated: "&TEXT(A2,"mmm d, yyyy h:mm AM/PM")
The result is Updated: May 6, 2026 2:30 PM. Use h:mm for a 12-hour-style hour and minutes, or hh:mm to include a leading zero. A code such as HH:mm is commonly used for 24-hour time. In date-time formats, the meaning of m can depend on its position: near hour or seconds codes it can mean minutes, while elsewhere it means month. When a result looks wrong, check the placement of the month and minute codes.
Handle empty cells and missing dates
A blank referenced cell can be treated like zero in calculations and display unexpectedly when passed into a date-formatting formula. If A2 may be empty, test for an empty cell before formatting it so the label does not show an unintended date or number.
With an optional date in A2, enter:
=IF(A2="","","Due: "&TEXT(A2,"mmmm d, yyyy"))
The formula returns an empty string when A2 is blank; otherwise, it returns a label such as Due: May 6, 2026. If you prefer a visible prompt, replace the first empty string with text such as "Date not entered". This check is useful when a report should not display a misleading date for an incomplete row.
A cell can also contain text that looks like a date but is not stored as a valid date value. If TEXT does not produce the expected result, check whether the source cell is a real Excel date. Imported data, pasted values, and dates entered in a different regional format can leave date-looking text in the cell. Convert or clean the source data before relying on date formatting in the concatenation formula.
Why formatting the cell alone is not enough
Applying a date format to A2 affects the way A2 is displayed, not the value returned to a formula. Likewise, formatting the formula cell as a date cannot make a date fragment inside a sentence display differently. The formula has already built a text string, and Excel cannot apply one number format to just part of that string.
You can change the appearance of a standalone date cell by selecting it and opening Format Cells with Ctrl+1 on Windows. On Mac, use Command+1. Choose a date format or a custom format there. This is useful for keeping dates as dates in the worksheet, but for a concatenated label, put the desired format code inside TEXT.
Also remember that the result of concatenation is not suitable as a replacement for the original date if you need calculations. Keep the source date in its own cell and use a separate formula for the display label. That preserves a numeric date for sorting by date, calculating elapsed days, and applying date-based filters.
Common problems and checks
- The result is a number: Wrap the date reference in
TEXTand supply the desired format code. - The result shows the wrong month or day: Verify the format code and confirm the source is a real date, not ambiguous date text interpreted under different regional settings.
- The result includes an unwanted time: Use a date-only format such as
mmm d, yyyyrather than a code that includes hours or minutes. - The result has an extra space or missing punctuation: Check the quoted text fragments around the ampersands or function arguments.
- The output does not update as expected: Check that the formula references the intended source cell and that Excel calculation is not set to manual.
Excel has two date systems, the 1900 date system used by default in most Windows workbooks and the 1904 system available for workbook compatibility. They assign different serial values to the same calendar date. That difference is one reason not to interpret a raw serial number as a date without context. In normal use, TEXT formats the date value according to the workbook’s date system, but dates moved between workbooks using different systems may need checking.
Alternatives and when to use them
For a one-off message, the ampersand with TEXT is usually enough. Use CONCAT if you prefer to list multiple text pieces as function arguments. The older CONCATENATE function can also join text in many existing workbooks, but new formulas can use & or CONCAT. Whichever joining method you choose, explicitly format the date if the output must show a particular date style.
If the goal is only to show a date differently in a cell, do not concatenate it: keep it as a date and change its cell number format. If the goal is a human-readable sentence, a printable label, or a filename component, convert it to text as part of the formula. If another process must read the result as a date, keep a separate date column rather than expecting it to convert the concatenated text back automatically.
Frequently Asked Questions
Why does CONCAT show a number instead of a date?
Excel stores dates as serial numbers, and CONCAT joins the underlying value rather than copying the source cell’s display format. Use TEXT(date_cell,"format_code") as one of the joined pieces.
Can I use CONCAT instead of the ampersand?
Yes. Both can join text, but neither automatically preserves a referenced cell’s date display format. Put the date inside TEXT either way.
Does the concatenated result remain a real date?
No. A formula that joins a date with text returns text. Keep the original date value in a separate cell for calculations, date sorting, and date-based filtering.
How do I show the month name in the result?
Use mmm for an abbreviated month or mmmm for the full month name in the format argument, such as TEXT(A2,"mmmm d, yyyy").
How can I omit the label when the date cell is blank?
Use an IF test around the concatenation, such as =IF(A2="","","Due: "&TEXT(A2,"mmm d, yyyy")). This returns a blank result when A2 is empty.
Related
- Excel Data Model Relationships: How They Work in Reports
- Excel Data Model Calculated Field: What to Use Instead
- Excel Data Model: How to Combine Tables and Analyze Them
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formulas With Text: How to Combine Words and ValuesTo use text in an Excel formula, put literal words inside straight double quotation marks, such as ="Ready".…
- Excel CONCAT Formula: Combine Two Columns With a SpaceTo combine two columns in Excel, enter =CONCAT(A2," ",B2) in a blank cell, replacing A2 and B2 with…
- How to Compare Two Columns in Excel With a FormulaTo compare two Excel columns row by row, enter =IF(A2=B2,"Match","Different") in C2, then fill the formula down. This…
- Calculate CAGR Growth in Excel: Formula and ExamplesTo calculate compound annual growth rate (CAGR) in Excel, divide the ending value by the beginning value, raise…
- Excel Formula for Percentage Increase: Examples and TipsTo calculate percentage increase in Excel, subtract the old value from the new value, then divide by the…
- Excel SUMIF Formula Examples for Everyday TasksExcel’s SUMIF function adds values that meet one condition. With regions in A2:A7 and sales amounts in B2:B7,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.