To concatenate a date in Excel and keep it readable, combine the cell with the & operator and format the date with TEXT. For example, if a date is in B2, enter =TEXT(B2,"mmmm d, yyyy") to display it as January 5, 2026; add text or other cell values with & as needed.
Why dates can turn into numbers
Excel stores most dates as serial numbers: a count of days from a starting date, with the time represented as a fractional part of a day. The cell’s number format controls how that underlying value looks. A cell might display January 5, 2026, while the stored value Excel uses in calculations is a number.
When you join that value directly to text, Excel generally uses the underlying number rather than the date’s display format. That is why a formula can produce a result such as Event 46027 instead of Event January 5, 2026. The solution is to use TEXT to convert the date value to text in a specific format before joining it.
This distinction matters because formatting a cell and converting a value to text are different operations. Applying a date format changes how a value appears in its cell; it does not guarantee that another formula will use that appearance when it combines the value with text.
Use ampersand for a simple concatenation
The ampersand is a compact way to join values and is usually the easiest choice for a short formula. Assume A2 contains the event name Planning session, and B2 contains the date January 5, 2026. To join the event name, a separator, and the date, use:
With the event name in A2 and the date in B2, enter =A2&" - "&TEXT(B2,"mmmm d, yyyy"). The result is Planning session - January 5, 2026.
The quoted text " - " supplies a dash with a space on either side. You can change the separator to a comma, a colon, a slash, or a space. For example, with a city in A2 and a date in B2, =A2&", "&TEXT(B2,"mmm d, yyyy") produces a result such as Boston, Jan 5, 2026. The date format belongs inside the second argument of TEXT.
To enter a formula, select the result cell, type the formula beginning with an equals sign, and press Enter. To use the same pattern on later rows, drag the fill handle from the lower-right corner of the result cell down the column. Relative references such as A2 and B2 adjust to A3 and B3 as the formula fills down.
Choose a date format that fits the result
The second argument of TEXT is a format code, written as text. Choose a format that suits the destination: a report label may need a full month name, while a filename or compact identifier may be clearer with year, month, and day in numeric order.
"mmmm d, yyyy"displays January 5, 2026."mmm d, yyyy"displays Jan 5, 2026."mm/dd/yyyy"displays 01/05/2026."yyyy-mm-dd"displays 2026-01-05."dddd, mmmm d"displays Monday, January 5.
For example, if B2 contains January 5, 2026 and you want an unambiguous year-first date, enter =TEXT(B2,"yyyy-mm-dd"). The returned text is 2026-01-05. This order is often useful in filenames and data exports because dates sort in calendar order when their components use fixed-width numeric formatting.
Format codes are not the same as the date format shown in the Home tab’s Number group. Changing the display format of B2 does not change the code in a formula. Also, a result created with TEXT is text, not a date value. It is suitable for labels and output, but it will not behave like a date in date arithmetic unless you convert it back to a date value.
Use CONCAT or TEXTJOIN when joining several items
For a couple of pieces, & is straightforward. Excel also offers CONCAT, which combines values or ranges, and TEXTJOIN, which adds a chosen delimiter and can skip empty cells. These functions are useful when a result has multiple parts, but they do not automatically preserve a date’s displayed format. Wrap each date that needs a readable appearance in TEXT.
Assume A2 contains a person’s name, B2 a meeting date, and C2 a location. To join all three with a vertical bar separator, enter:
With the name in A2, the date in B2, and the location in C2, use =CONCAT(A2," | ",TEXT(B2,"mmm d, yyyy")," | ",C2). If A2 is Morgan, B2 is January 5, 2026, and C2 is Room 4, the result is Morgan | Jan 5, 2026 | Room 4.
For a list in which some fields may be blank, TEXTJOIN can avoid repeating separators between empty cells. With a name in A2, a possibly blank department in B2, and a date in C2, enter =TEXTJOIN(" - ",TRUE,A2,B2,TEXT(C2,"mmmm d, yyyy")). The arguments specify the separator, whether to ignore empty cells, and the items to join. If B2 is blank, Excel skips that empty value and does not insert an extra dash for it.
Handle dates that include a time
A date-and-time value includes both a date and a fractional time component. If you use a date-only format in TEXT, the time is omitted from the joined result. If the time is important, include time codes in the format string.
With a timestamp in B2, enter =TEXT(B2,"mmm d, yyyy h:mm AM/PM") to display a result like Jan 5, 2026 9:30 AM, assuming B2 contains that date and time. Use HH:mm for a 24-hour clock, such as 09:30. The format string only changes the text shown in the result; it does not round or alter the underlying timestamp in B2.
When combining a start date and an end date, format each one separately. With the start date in A2 and the end date in B2, =TEXT(A2,"mmm d")&"–"&TEXT(B2,"mmm d, yyyy") can return Jan 5–Jan 8, 2026. This abbreviated style is concise, but it assumes both dates are in the same year. If they might cross a year boundary, include the year on both dates to avoid ambiguity.
Common problems and how to fix them
- A serial number appears. Wrap the date reference in
TEXT, and choose the desired format code. Formatting the original cell alone may not fix concatenation. - The formula shows as text or does not calculate. Check that it starts with
=, that the cell is not formatted as Text, and that Show Formulas has not been turned on. If you change a Text-formatted cell to General, re-enter the formula so Excel evaluates it. - The result has an unwanted decimal or time. The underlying value may include a time. Use a date-only format in
TEXTto omit it, or include a time format if it should appear. - The displayed month or day is unexpected. Numeric dates such as 03/04/2026 can be interpreted differently depending on regional settings. Check that the source cell contains the intended date value rather than ambiguous text, and use a spelled-out month or year-first format in the output.
- The formula gives a syntax error. Check that quotation marks are straight double quotes, parentheses are balanced, and separators between function arguments match your Excel regional settings. The examples here use commas, as in standard Microsoft 365 for Windows setups; some regional configurations use semicolons.
Another common misconception is that a concatenated date remains a date. Once TEXT turns a date into formatted text, the combined result is a text string. You can still search, copy, or display it as a label, but sorting such strings may not sort them chronologically. For example, month names sorted alphabetically do not follow calendar order. Keep the original date in a separate column if you need date calculations or reliable chronological sorting.
Where to use the formula and what to expect
Enter the formula in a separate result column so that the original date remains available for calculations, filtering, and sorting. If you need to provide a fixed text snapshot rather than a formula, copy the results and use Home > Paste > Paste Values. That replaces the formulas with their current text results, so later changes to the source cells will not update them.
In Microsoft Excel for Microsoft 365 on Windows, the formulas above use standard worksheet functions and the ampersand operator. They also work in current Excel for Mac and Excel for the web. Ribbon placement and some keyboard shortcuts differ across platforms, but the formulas themselves do not. Excel may use different argument separators under regional settings, so follow the separator convention accepted by your installation.
If another system needs an actual date rather than a display label, export or pass the original date value separately whenever possible. A combined string is convenient for a heading or message, but it is less flexible as structured data. Keeping fields separate makes it easier for another spreadsheet, database, or application to interpret each piece correctly.
Frequently Asked Questions
How do I concatenate a date without getting a number?
Use TEXT around the date reference before joining it. With the date in B2, =TEXT(B2,"mmmm d, yyyy") returns a readable date string. To add a label, join that result with text using &.
Can I use CONCATENATE to join dates?
Yes. The older CONCATENATE function can join text and cell references, but you still need to format date values with TEXT first. CONCAT and & are other options; the key is formatting the date, not which joining method you choose.
Does concatenating a date keep it usable for date calculations?
No. A date converted with TEXT and joined to other content becomes text. Retain the original date in another cell for calculations, date filters, or chronological sorting.
How do I include the time as well as the date?
Use a date-and-time format in TEXT. With a timestamp in B2, =TEXT(B2,"mmm d, yyyy h:mm AM/PM") displays the date and a 12-hour time. Choose a 24-hour format such as HH:mm if that better suits your data.
Why does my formula use semicolons instead of commas?
Excel’s list separator can depend on regional settings. The examples use commas between function arguments, but some installations require semicolons. Use the separator your Excel accepts; do not change the commas inside quoted text that is meant to appear in the result.
Related
- Change Block Capitals to Lowercase in Excel
- Center Across Selection in Excel: Add It to Quick Access
- Cell in Microsoft Excel: Meaning, Types, and How to Use It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Budget Spreadsheet Examples: Templates and FormulasBudget spreadsheet examples range from a simple monthly income-and-expense list to zero-based, annual, and small-business budgets. For a…
- Excel SUMIFS With OR Criteria: Formulas and ExamplesExcel’s SUMIFS function does not provide a built-in OR operator between criteria: to match one condition or another,…
- Excel OFFSET Formula Explained: Syntax and ExamplesExcel’s OFFSET function returns a reference to a cell or range located a specified number of rows and…
- Excel XLOOKUP Practice Examples: Formulas and TipsExcel XLOOKUP practice examples are easiest to learn by matching a lookup value to a column and returning…
- Excel Page Break Formula: What Works and What Doesn’tNo Excel worksheet formula can insert a print page break or tell Excel exactly where a printed page…
- Excel Find and Replace: Values, Formulas, and OptionsTo find and replace values in Excel, press Ctrl+H on Windows, enter the text or value under Find…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.