Concat Excel Cells with Dates: Formulas, Fixes, and Tips

Formulas & functions · Updated November 18, 2026

To concatenate text and a date in Excel, use the TEXT function to format the date before joining it to the text. With a label in A2 and a real Excel date in B2, enter =A2&" "&TEXT(B2,"mmmm d, yyyy") to produce a result such as “Invoice due March 8, 2026.” Without TEXT, Excel may show the date’s underlying serial number instead of a readable date.

The Basic Formula and Why It Works

Excel stores dates as numbers so it can calculate with them. The date that appears in a cell is usually just a display format applied to that number. Joining a date cell to text with the ampersand operator does not automatically carry over the date cell’s visual formatting; Excel converts the stored value for the formula result, which can look like an unexplained number.

In the opening example, A2&" "&TEXT(B2,"mmmm d, yyyy") has three parts. A2 supplies the label, the quoted space separates the label from the date, and TEXT turns the date into text in the requested format. The ampersands join those pieces into one text value. The formula changes its result if either input changes.

Use the actual cell references and words from your worksheet. For example, if A2 contains “Meeting:” and B2 contains a date, the formula returns “Meeting: March 8, 2026.” If you want different punctuation, put it inside a quoted string. A hyphen, comma, or phrase such as “on” is ordinary text to Excel.

Choose a Date Format

The format string inside TEXT controls how the date appears in the combined result. Common choices include:

  • TEXT(B2,"m/d/yyyy") for a compact date such as 3/8/2026.
  • TEXT(B2,"mmm d, yyyy") for Mar 8, 2026.
  • TEXT(B2,"dddd, mmmm d") for Sunday, March 8.
  • TEXT(B2,"yyyy-mm-dd") for 2026-03-08, a year-month-day style often useful in exports.

These are format examples, not complete formulas to paste on their own. To use one, place it as the second argument of TEXT in the joining formula. The format string affects only the text returned by the formula; it does not change the date stored in B2 or the way B2 is displayed elsewhere.

Format codes are not the same as literal words. To include a word such as “due” in the output, put it in the joining text, as in A2&" due "&TEXT(B2,"mmm d"). That example assumes A2 contains a label and B2 contains a date. In a custom format string, literal text may need quotation marks or escaping; adding words as separate concatenated text is usually easier to read and maintain.

Combine a Date with Several Cells

For a simple combination, the ampersand operator is clear and works across current Excel versions. The CONCAT function is another option when you want to list the pieces as arguments. With a person’s name in A2 and a date in B2, this formula creates a sentence fragment:

With the name in A2 and a genuine date in B2, use =CONCAT(A2," is scheduled for ",TEXT(B2,"dddd, mmmm d, yyyy")). If A2 is “Jordan” and B2 is March 8, 2026, the result is “Jordan is scheduled for Sunday, March 8, 2026.”

When you are joining a variable number of cells and want a delimiter, TEXTJOIN can be more convenient. With a name in A2, a date in B2, and a location in C2, use =TEXTJOIN(" | ",TRUE,A2,TEXT(B2,"mmm d, yyyy"),C2). The result might be “Jordan | Mar 8, 2026 | Room 4.” The second argument, TRUE, tells Excel to ignore empty arguments. The date still needs to be formatted with TEXT before it is joined.

CONCAT and TEXTJOIN are available in modern Excel, including Microsoft 365. For compatibility with older spreadsheets, the ampersand operator is a straightforward choice. None of these joining methods automatically applies the source cell’s date display format to the final text.

Include a Time Along with the Date

If the source cell contains both a date and a time, include time codes in the TEXT format string. With an event description in A2 and an Excel date-and-time value in B2, use =A2&" at "&TEXT(B2,"m/d/yyyy h:mm AM/PM"). A value for March 8, 2026 at 2:30 PM will appear as “Event at 3/8/2026 2:30 PM.” Change the pattern to match the style your audience needs.

For a 24-hour clock, a pattern such as h:mm gives a result like 14:30; add a date pattern before it if the date should also appear. If the source value has no time component, the formatted output may show midnight when a time is requested. Conversely, if the cell contains a time but the format string includes only a date, the time will not appear in the joined text.

Handle Blank Dates and Missing Values

A blank date cell can lead to an incomplete message or an unwanted date-like value, depending on the formula and the cell contents. If the whole result should be blank whenever B2 is empty, use an IF test. With a label in A2 and an optional date in B2, enter =IF(B2="","",A2&" "&TEXT(B2,"mmmm d, yyyy")). This returns an empty string when B2 is blank and builds the text only when B2 has a value.

If the date is optional but the label should remain visible, use a different condition. With a label in A2 and an optional date in B2, =IF(B2="",A2,A2&" "&TEXT(B2,"mmmm d, yyyy")) returns just the label when there is no date. Choose the behavior that fits the purpose of the output, such as a report line, email subject, or printed notice.

An apparently blank cell may contain a formula returning an empty string, spaces, or an error rather than being truly empty. A simple B2="" test treats a truly empty cell and a formula result of an empty string as blank, but spaces are still characters. If results look inconsistent, inspect the source cell and remove unintended spaces or resolve any underlying errors.

Common Problems and Their Fixes

  • The output is a number: Wrap the date reference in TEXT and specify the desired date pattern. This is the usual fix when concatenation exposes Excel’s stored date value.
  • The result shows a strange date or an error: Check whether the source is a real Excel date rather than text that only looks like a date. Imported text dates can be interpreted differently depending on their pattern and regional settings. Convert or correct the source value before relying on date formatting.
  • The month or day is not what you expected: Confirm the source date and the format pattern. For example, m/d/yyyy can be ambiguous to readers in regions that use day/month order; a month name or an ISO-style year-first pattern can be clearer.
  • The date changes after copying the formula: Relative references such as B2 adjust when copied. Use an absolute reference such as $B$2 if every copied formula should keep pointing to the same date cell.
  • The formula is rejected: Check that quotation marks and parentheses are balanced and that your Excel regional settings use commas as argument separators. Some regional configurations use semicolons instead of commas in formulas.

For the text-date issue, a visual check alone is not always enough: a cell can be formatted to look like a date while holding text. A useful next step is to test the source in a spare cell or correct the import at its origin. Excel’s date interpretation depends on the input, so do not assume that every string such as 03/08/2026 means the same date in every locale.

Formula Formatting Versus Cell Formatting

Changing the number format of the source date cell does not generally control the text created by a concatenation formula. For example, B2 might be displayed as “March 8, 2026” on the worksheet, while a formula that joins B2 directly to a label still converts its stored numeric value rather than copying that appearance. This is why TEXT belongs in the formula when the date is part of a sentence or label.

Cell formatting remains useful when you want the date in B2 itself to look different while keeping it available for date calculations. Select the date cell and use Home > Number Format, or open Format Cells with Ctrl+1 on Windows. On Mac, use Command+1 to open Format Cells. These steps affect the cell’s display, not the text returned by a separate concatenation formula.

There is a practical distinction: a date kept as a date can be sorted, filtered, and used in date arithmetic, while the combined result is text. A combined label such as “Due March 8, 2026” is suitable for display, but it is not a substitute for the original date value in calculations. Keep the source date in its own cell when you may need to calculate deadlines, group records by date, or sort chronologically.

Which Method Should You Use?

Choose the joining method based on the shape of the result, not on the date itself. Use & for a short formula with a few pieces; it makes the order and punctuation visible. Use CONCAT if you prefer function arguments for a fixed sequence. Use TEXTJOIN when a repeated delimiter or ignored blank cells will make the formula easier to manage. In every case, apply TEXT to the date when you want a predictable, readable date in the output.

It is also worth deciding whether a single text result is really needed. If the goal is only to display a date with a label in a report, a separate label column and date column may be easier to sort, filter, and reuse. Concatenation is most useful when a combined text string is specifically needed, such as a message, a printable description, or a file label.

Frequently Asked Questions

How do I combine text and a date without getting a number?
Put the date cell inside TEXT with a format such as TEXT(B2,"mmm d, yyyy"), then join that result to the text with &, CONCAT, or TEXTJOIN. The format pattern determines the date shown.

Can I concatenate cells using CONCAT instead of an ampersand?
Yes. CONCAT joins text arguments, but it does not automatically preserve a date cell’s display format. Format the date with TEXT as one of the arguments.

How do I add a comma or words around the date?
Include punctuation or words as quoted text between the joined pieces. For example, use a separator such as ", due " between the label and the formatted date. Be sure to include spaces where the output needs them.

Can I concatenate a date and time in one cell?
Yes. Use a date-and-time format pattern inside TEXT, such as m/d/yyyy h:mm AM/PM, and join its result to the other text. The source cell must contain the time as part of its value for an actual time to appear.

Will the formula work in Excel for Mac or Excel for the web?
The same basic functions and formula structure work in current Excel for Mac and Excel for the web. Formula argument separators can differ with regional settings, and keyboard shortcuts for Format Cells differ between Windows and Mac.

Keep the Original Date for Later Use

When you build a combined text value, preserve the original date in its own cell and use the formula only for presentation. That keeps sorting and calculations reliable while giving you control over exactly how the date reads in the finished text. The key rule is simple: concatenate text with a formatted date, not with the raw date value.

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.