If A2 contains Invoice date: and B2 contains March 4, 2026, join them with =A2&" "&TEXT(B2,"mmmm d, yyyy"). The TEXT function preserves the date format you choose in the combined result; simply joining a date cell to text usually exposes its underlying number instead.
Why dates change when you join them
Excel normally stores a date as a number that represents a day in its date system. The cell’s number format tells Excel how to display that number as a calendar date. For example, the same date value can appear as 3/4/2026, Mar 4, 2026, or Wednesday, March 4, 2026, depending on the cell format.
When you concatenate a date with text using the ampersand operator, CONCAT, or a similar function, Excel creates text. The new text does not inherit the date cell’s display format. As a result, a formula such as =A2&B2 may show a serial number after the label rather than a readable date. The date has not been damaged; Excel is displaying its stored number as part of the text.
The fix is to convert the date to formatted text as part of the join. TEXT(value, format_text) takes a date value and a format pattern, then returns text in that pattern. This is useful for labels, messages, reports, and exported text, but the result is text rather than a date value you can use directly for date arithmetic.
The simplest formula for a readable date
With the label in A2 and the date in B2, use =A2&" "&TEXT(B2,"mmm d, yyyy"). If A2 contains Invoice date: and B2 is March 4, 2026, the result is Invoice date: Mar 4, 2026. The spaces inside the quoted strings control spacing in the finished text.
You can also build the whole label in the formula rather than keeping it in a separate cell. With the date in B2, ="Invoice date: "&TEXT(B2,"mmmm d, yyyy") returns Invoice date: March 4, 2026. Choose the format pattern that suits the audience and the available space.
For a short numeric date, with the date in B2, =TEXT(B2,"yyyy-mm-dd") returns 2026-03-04. This year-month-day order is often easier to sort or scan in text lists than a date such as 3/4/2026, whose month and day order can be ambiguous across countries.
In Microsoft 365 for Windows, enter the formula in the result cell and press Enter. If Excel shows a formula error because of regional settings, your installation may use semicolons between function arguments; replace the argument separators while leaving punctuation inside the quoted format string unchanged.
Pick a date format that fits the message
The format pattern inside TEXT determines what appears in the result. Common choices include:
"m/d/yy"for a compact date, such as 3/4/26."mmm d, yyyy"for Mar 4, 2026."mmmm d, yyyy"for March 4, 2026."dddd, mmmm d, yyyy"for Wednesday, March 4, 2026."yyyy-mm-dd"for 2026-03-04.
In these patterns, repeated letters control detail: m or mm gives a numeric month, mmm gives an abbreviated month name, and mmmm gives the full month name. A single d gives the day number, while dddd gives the weekday name. Use yy for a two-digit year or yyyy for a four-digit year.
Formatting can depend on the language and regional settings in Excel. Month and weekday names may appear in the locale used by the installation, and numeric conventions can be interpreted differently by people in different regions. If the text will be shared widely, a pattern such as yyyy-mm-dd avoids much of that ambiguity. Check the actual displayed result in your workbook, especially when names or dates must match a specific language.
Join several columns without losing the date style
For a short combination, use the ampersand operator and wrap each date that needs a chosen display style in TEXT. With a person’s name in A2 and a date in B2, =A2&" — "&TEXT(B2,"mmm d, yyyy") joins the name and date with a dash. If A2 is Riley Chen and B2 is March 4, 2026, it returns Riley Chen — Mar 4, 2026.
CONCAT is another option for joining pieces. With the label in A2 and date in B2, =CONCAT(A2," ",TEXT(B2,"mmm d, yyyy")) produces the same kind of result as the ampersand formula. CONCAT is available in current Excel versions, including Microsoft 365; older workbooks may use the older CONCATENATE function. In all cases, format the date explicitly with TEXT.
When you have many parts, TEXTJOIN can apply a separator and optionally skip empty cells. With a location in A2, a date in B2, and a status in C2, =TEXTJOIN(" | ",TRUE,A2,TEXT(B2,"mmm d, yyyy"),C2) returns, for example, North | Mar 4, 2026 | Paid when those are the three values. The second argument, TRUE, tells Excel to ignore empty arguments. The date still needs TEXT; TEXTJOIN does not preserve a source cell’s number format by itself.
Include a time as well as a date
A date-and-time value also needs an explicit format when converted to text. With a date and time in B2—for example, March 4, 2026 at 2:30 PM—use =TEXT(B2,"mmmm d, yyyy h:mm AM/PM"). The result is March 4, 2026 2:30 PM. Use hh:mm for a 24-hour clock, such as 14:30, or add seconds with h:mm:ss AM/PM.
For a range, put each date inside its own TEXT call. With a start date in A2 and an end date in B2, =TEXT(A2,"mmm d, yyyy")&" to "&TEXT(B2,"mmm d, yyyy") can return Mar 4, 2026 to Mar 8, 2026. This is a text label: it will not recalculate as a date range unless the underlying cells or formula inputs change.
Common problems and how to fix them
- A number appears instead of a date. The date was joined without conversion. Wrap the date reference in
TEXT, then specify the desired pattern. - The result has extra or missing spaces. Add spaces explicitly inside quoted text, such as
" ", or remove them if adjacent parts already contain spacing. Excel does not automatically add separators. - The date appears as text that looks wrong. Check that the source cell contains a real Excel date, not text that merely resembles one. If it is already text,
TEXTmay not interpret it as expected; convert or correct the source value first. - The formula displays as text instead of calculating. Check whether the cell is formatted as Text, or whether the formula begins with an apostrophe. Set the cell to General, re-enter the formula, and press Enter.
- The output uses an unexpected month or day order. Choose a clear format such as
yyyy-mm-dd, and consider the workbook’s regional settings and the conventions of the people who will read it. - A date looks different after copying it elsewhere. The combined result is text. Its characters travel with the formula result, but the source date’s number format does not apply to it.
If a formula returns #VALUE!, check the date input and the formula’s quotation marks and parentheses. A blank date cell can also produce an output that looks odd when combined with a label. Decide whether a blank should leave the whole result empty or show a placeholder, then build that behavior into the formula rather than relying on cell formatting.
Concatenated text versus formatting the date cell
If you only want a date cell to look different, do not concatenate it. Apply a date number format to the cell instead: select the cell, press Ctrl+1 on Windows, choose the date or custom format options, and select or enter a format. On Mac, use Command+1 to open Format Cells. This changes how the date is displayed while keeping it a date value that can still be sorted, filtered, or used in date calculations.
Concatenation is the right choice when the date must appear inside a sentence or label, such as Delivery expected: March 4, 2026. It is also useful when producing a text string for a report or message. The trade-off is that the combined result is text: Excel cannot treat the whole phrase as a date, and changing the result cell’s number format will not restyle the date embedded in the phrase.
When to use a different approach
Use a formatted date cell when you need calculations, sorting by date, or filtering based on date values. Use TEXT plus concatenation when the goal is readable text. If the text is only for a visual report, you can also keep the date in its own cell and place a separate label nearby; that avoids turning a useful date value into text.
For repeated reporting, consider keeping the source date and the display formula in separate columns. That makes it clear which value is suitable for calculations and which is a presentation string. It also makes later changes easier: you can change the date format in one formula without altering the original date data.
Frequently Asked Questions
Why does Excel show a number when I concatenate a date?
Excel stores dates as numbers and applies a cell format to display them as dates. Concatenation creates text and does not carry that cell format over. Use TEXT(date_cell,"format") for the date portion.
Can I concatenate a date and keep the result as a real date?
No. A result that combines a date with ordinary text is text, not a date serial value. Keep the date in a separate cell if you need date calculations, and create a separate text formula for the label.
Does CONCAT preserve date formatting?
No. CONCAT joins values but does not copy the source cell’s display format. Wrap each date that needs a particular appearance in TEXT before passing it to CONCAT.
How do I concatenate a date without the time?
With the date and time in B2, use a format pattern that contains only the date, such as =TEXT(B2,"mmm d, yyyy"). The time remains in the underlying value but is omitted from this text result.
Will the formula work in Excel for Mac or Excel for the web?
The TEXT, ampersand, CONCAT, and TEXTJOIN approach works in current Excel for Mac and Excel for the web as well as Microsoft 365 for Windows. Ribbon locations can differ, but the formula method is the same.
Related
- Bps Number Format in Excel: Display Basis Points
- Bottom Border Excel Shortcut and How to Use It
- Billion Number Format in Excel: Display Values in Billions
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Power Query IF Examples: Conditional Logic in ExcelIn Power Query, write an IF test in M as if condition then value_if_true else value_if_false. For example,…
- Excel Quantity Analysis: Formulas, Checks, and ExamplesExcel quantity analysis means organizing quantity records and summarizing them to answer questions such as how many units…
- VLOOKUP Between Two Sheets in Excel: A Practical GuideTo look up a value from one Excel sheet on another, enter a VLOOKUP formula such as =VLOOKUP(A2,Products!$A$2:$C$100,3,FALSE).…
- Find Common Names in Excel with Formulas and FormattingTo find names that appear in two Excel lists, use COUNTIF to check whether each name in the…
- Sequence Number Formula in Excel: Methods That WorkFor a numbered list starting in cell A2, enter =ROW()-1 and fill the formula down; the first result…
- String Handling Functions in C: A Practical GuideC string-handling functions are declared in the standard header <string.h> and work with null-terminated character arrays. The most-used…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.