Concatenate Dates in Excel: Formulas and Examples

Formulas & functions · Updated November 22, 2026

To concatenate a date in Excel, convert the date to the display format you want with the TEXT function, then join it to other text with &, CONCAT, or TEXTJOIN. For example, with a date in A2 and an event name in B2, =TEXT(A2,"mmmm d, yyyy")&" - "&B2 can return March 8, 2026 - Meeting.

Why dates need special treatment

Excel stores dates as serial numbers so it can sort them and use them in calculations. The date you see in a cell is usually a number displayed with a date format. When a formula joins that cell to text, Excel may use the underlying serial number rather than the familiar date display. A result such as 46089 - Meeting is therefore usually a formatting issue, not a bad date.

The TEXT function solves this by turning a numeric value into text using a format code. Once the date has become text in the desired format, it can be joined to a label, description, or another value. This distinction matters: the completed concatenated result is text, not a date value that Excel can directly sort chronologically or use in date arithmetic.

Combine a date with text using ampersand

The ampersand is a straightforward way to join values in a formula. Put the date inside TEXT, specify a date format, and place literal spaces or punctuation inside quotation marks. For example, with a date in A2 and the word Meeting in B2, use =TEXT(A2,"mmmm d, yyyy")&" - "&B2. If A2 contains March 8, 2026, the result is March 8, 2026 - Meeting.

The formula has three parts: the formatted date, the separator, and the cell containing the event name. You can change the separator without changing the source cells. A comma and space could replace the hyphen, or you could use words such as " on ". For a sentence-style result, with the date in A2 and the activity in B2, use =B2&" is scheduled for "&TEXT(A2,"mmmm d, yyyy"). If B2 contains Review, the result is Review is scheduled for March 8, 2026.

Use the ampersand when the order and punctuation are simple and you want to see exactly how the pieces fit together. It works in current Excel for Microsoft 365 on Windows, Mac, and the web.

Choose a date format that suits the result

The format code inside TEXT controls how the date appears in the joined result. It does not change the original date in the cell. Common codes include:

  • "mmmm d, yyyy" for March 8, 2026.
  • "mmm d, yyyy" for Mar 8, 2026.
  • "mm/dd/yyyy" for 03/08/2026.
  • "yyyy-mm-dd" for 2026-03-08, a clear year-month-day style.
  • "ddd, mmm d" for Sun, Mar 8.

With the date in A2, =TEXT(A2,"yyyy-mm-dd") returns 2026-03-08 when A2 contains March 8, 2026. Choose a format that makes sense for the reader: a month name can reduce confusion between day and month, while a compact numeric format may suit file labels or reports. The displayed month and day names can depend on Excel’s regional settings. For example, a workbook configured for another language may display localized names.

In a format code, m represents a month when used as a date format, while mm adds a leading zero and mmmm spells out the month. The same letters can represent minutes in a time format, so use a complete date-and-time pattern when formatting both. For example, with a date and time in A2, =TEXT(A2,"mmm d, yyyy h:mm AM/PM") can return Mar 8, 2026 9:30 AM, assuming A2 includes that time.

Use CONCAT or TEXTJOIN

CONCAT is an alternative to ampersands when you want to pass several pieces of text as arguments. With the date in A2 and the event in B2, =CONCAT(TEXT(A2,"mmm d, yyyy")," | ",B2) returns Mar 8, 2026 | Meeting. As with the ampersand approach, format the date before joining it. CONCAT does not automatically insert spaces or punctuation.

TEXTJOIN is useful when you want one delimiter between several items, especially when some cells may be blank. With a date in A2, an event in B2, and a location in C2, =TEXTJOIN(" | ",TRUE,TEXT(A2,"mmm d, yyyy"),B2,C2) returns Mar 8, 2026 | Meeting | Room 4 if C2 contains Room 4. The TRUE argument tells Excel to ignore empty values, so blank fields do not create extra separators. Both CONCAT and TEXTJOIN are available in current Microsoft 365 Excel.

The older CONCATENATE function is still supported in Excel, but Microsoft provides CONCAT as its newer replacement. It is not necessary to use a special concatenation function: & remains a practical choice for short formulas, while TEXTJOIN is convenient for lists with a repeated delimiter.

Include a date and time

Excel can store a time as part of a date value. If you concatenate that value without formatting it, the result may show a serial number or omit the time you expected. Use a format pattern that includes both date and time. With a date and time in A2, =TEXT(A2,"mmmm d, yyyy")&" at "&TEXT(A2,"h:mm AM/PM") returns March 8, 2026 at 9:30 AM if A2 contains that date and time.

You can also keep the date and time together in one call: with the same value in A2, =TEXT(A2,"mmm d, yyyy h:mm AM/PM") returns Mar 8, 2026 9:30 AM. Use hh:mm for a 24-hour clock, such as 21:30, or h:mm AM/PM for a 12-hour clock. If the date and time are in separate cells, format each one separately before joining them. Make sure the cells contain actual Excel date or time values; text that merely looks like a date may not behave the same way.

Handle blank cells and keep the source date usable

Concatenation is handy for a display label, but it should not replace the original date when you need to sort, filter, or calculate. Keep the date in its own cell and put the combined text in a separate column. That way, the date remains a numeric value and the label is available for display, export, or a message.

To avoid showing a label when A2 is blank, use an IF check. With the date in A2 and the event name in B2, =IF(A2="","",TEXT(A2,"mmmm d, yyyy")&" - "&B2) returns an empty result when A2 is empty; otherwise, it returns a formatted date followed by the event. This can make a report look cleaner while rows are incomplete. If the date exists but B2 is blank, the formula still displays the date and the separator. You can add another condition if your layout requires both fields before showing a result.

Remember that a joined result is text. If you later need to calculate a number of days from the date, refer to the original date cell rather than trying to calculate from the combined label. Keeping raw values separate from presentation text also makes the workbook easier to maintain.

Common problems and how to fix them

  • A serial number appears instead of a date. Wrap the date reference in TEXT and specify a format code, such as "mmm d, yyyy".
  • The output has no spaces. Excel does not add separators automatically. Include them as quoted text, for example " - " or " on ".
  • The date looks wrong or is left-aligned. The source may be text rather than a real date value, or it may have been interpreted according to a different regional date order. Check the source and regional settings before changing the formula.
  • The formula displays literally instead of calculating. Check that the cell is not formatted as Text, that the formula begins with =, and that Show Formulas is not enabled. Changing a cell from Text to General and re-entering the formula can help.
  • The result has an unexpected language or month name. The date names produced by TEXT can reflect system or workbook regional settings. A numeric format such as "yyyy-mm-dd" avoids spelled-out month names.

When the date is imported from another system, confirm whether Excel recognizes it as a date before concatenating. If it is stored as text, formatting it with TEXT may not convert it into a true date. Converting the source to an actual Excel date first is more reliable than trying to repair the joined text afterward.

Frequently Asked Questions

How do I concatenate a date and text in Excel?
Use TEXT to format the date and then join it with text using &, CONCAT, or TEXTJOIN. For instance, with a date in A2 and text in B2, =TEXT(A2,"mmm d, yyyy")&" - "&B2 gives a readable date-and-label result.

Why does Excel show a number when I concatenate a date?
Dates are stored as serial numbers. When you join a date cell with text, Excel may use that underlying number. Wrap the date reference in TEXT and provide a format code to show a date instead.

Can I concatenate a date without changing its format in the original cell?
Yes. The format code in TEXT affects the formula result only. The source date cell keeps its existing value and cell formatting.

Can I concatenate dates and still sort the results by date?
A concatenated label is text, so it may not sort chronologically as expected. Keep the actual date in a separate column and sort by that column. A year-month-day text pattern can sort in calendar order as text in some cases, but it is safer to sort the underlying date value.

Should I use CONCATENATE, CONCAT, or the ampersand?
For a short formula, use & if you find it easiest to read. Use CONCAT to join multiple pieces as function arguments, or TEXTJOIN when you want a delimiter and need to handle blank values. The older CONCATENATE function remains available, but it is generally not needed for new formulas.

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.