Concatenate Date Formula in Excel: Keep Dates Readable

Formulas & functions · Updated November 22, 2026

To concatenate a date with text in Excel, wrap the date cell in the TEXT function so Excel displays it in the format you want. For example, if A2 contains a label and B2 contains a date, use =A2&" "&TEXT(B2,"mmmm d, yyyy") to return a readable result such as Invoice due March 7, 2026.

The basic date concatenation formula

Excel stores most dates as serial numbers, while a cell’s number format controls how those numbers appear on the worksheet. When a formula joins a date cell directly to text, the formula can use the underlying number instead of the date display. The result may look like a long number rather than a calendar date.

The TEXT function solves this by converting the date value to text in a specified display format before joining it to anything else. Assume A2 contains the text Invoice due and B2 contains the date March 7, 2026. Enter this formula in C2:

=A2&" "&TEXT(B2,"mmmm d, yyyy")

The result is Invoice due March 7, 2026. The first ampersand joins A2 to a space; the second joins that text to the formatted date. The spaces inside the quotation marks are intentional: concatenation does not add spaces automatically.

Why a date can turn into a number

Excel dates are stored as numbers so that the program can sort them, calculate elapsed days, and use them in other date calculations. A date cell might display as March 7, 2026, even though its stored value is a serial number. A formula that joins the cell directly to text can expose that underlying value.

Changing the date cell’s appearance with the Home tab’s number-format controls does not necessarily change what a concatenation formula reads. That formatting belongs to the original cell; the formula needs its own format instruction. Applying a date format to the formula result also will not turn a text string back into a date, because the result of joining text and a formatted date is text.

This distinction matters when a result is intended for a sentence, report heading, email, label, or exported file. If you need to do date arithmetic later, keep the real date in its own cell and use a separate formula for the human-readable sentence.

Choose a date format that suits the result

The second argument of TEXT is a format code in quotation marks. It determines how the date appears in the joined result. With B2 containing March 7, 2026, formats can make the same date suit different audiences:

  • =TEXT(B2,"mmmm d, yyyy") displays March 7, 2026.
  • =TEXT(B2,"mmm d, yyyy") displays Mar 7, 2026.
  • =TEXT(B2,"mm/dd/yyyy") displays 03/07/2026.
  • =TEXT(B2,"yyyy-mm-dd") displays 2026-03-07.
  • =TEXT(B2,"dddd, mmmm d") displays Saturday, March 7.

Each example assumes B2 contains the actual date March 7, 2026, rather than text that merely resembles a date. The weekday example reflects the calendar for that date. Choose a format that is unambiguous for the readers: a numeric date such as 03/07/2026 can be interpreted differently in regions that order month and day differently, while a month name makes the meaning clearer.

Format codes are not quite the same as the way you would type a date normally. For instance, mmmm spells out the month, while mmm abbreviates it. The format is inside quotation marks, but the date reference is not.

Build a formula step by step

To make a reusable label, place a description in one column, a date in another, and the result in a third. For example, assume A2 contains Appointment, B2 contains March 7, 2026, and you want the result in C2.

  1. Select C2, or the cell where the finished wording should appear.
  2. Type the label reference, an ampersand, and the separator you want in quotation marks.
  3. Add TEXT around the date reference and provide a date format code.
  4. Press Enter and check that the displayed month, day, and year are what you expect.
  5. To apply the pattern to more rows, copy or fill the formula down; relative references will adjust for each row.

For the example layout, enter this in C2:

=A2&" on "&TEXT(B2,"mmmm d, yyyy")

If A2 is Appointment and B2 is March 7, 2026, the result is Appointment on March 7, 2026. To create a filename-style label, assume B2 holds the date and C2 contains the text INV-24; enter this in D2:

=TEXT(B2,"yyyy-mm-dd")&"_"&C2

The result is 2026-03-07_INV-24. The year-month-day order is useful in many filenames because the date components sort from largest to smallest, though the best convention depends on the systems and people using those files.

Join two dates or several pieces of text

The same approach works when a sentence contains two dates. Assume A2 contains a start date of March 7, 2026, and B2 contains an end date of March 12, 2026. This formula produces a compact range:

=TEXT(A2,"mmm d")&" - "&TEXT(B2,"mmm d, yyyy")

The result is Mar 7 – Mar 12, 2026. Both date cells need their own TEXT format because each is converted separately. If the range crosses a year boundary, consider including the year on both dates to avoid ambiguity.

You can also add more literal text or cell references by connecting each part with an ampersand. Assume A2 contains the event name, B2 the event date, and C2 the venue. In D2, use:

=A2&" — "&TEXT(B2,"dddd, mmmm d, yyyy")&" at "&C2

If A2 is Staff meeting, B2 is March 7, 2026, and C2 is Room 4, the output is Staff meeting — Saturday, March 7, 2026 at Room 4. Be consistent about where spaces and punctuation go: they must be included in the text pieces in quotation marks.

Ampersand, CONCAT, or CONCATENATE?

The ampersand operator is a straightforward choice for a short formula. It is available in Excel for Microsoft 365 and makes the joining points visible, but a formula with many parts can become harder to scan. The date still needs TEXT regardless of which joining method you choose.

Excel also offers CONCAT. Assuming A2 contains Invoice due and B2 contains March 7, 2026, this formula returns Invoice due March 7, 2026:

=CONCAT(A2," ",TEXT(B2,"mmmm d, yyyy"))

CONCATENATE is the older function name and remains useful in workbooks that already use it. With the same A2 and B2 layout, the following returns the same result:

=CONCATENATE(A2," ",TEXT(B2,"mmmm d, yyyy"))

For a simple date label, there is usually no practical need to replace a working ampersand formula with one of these functions. Pick the style that makes your workbook easiest to understand, and do not confuse a joining function with a date formatter: TEXT controls how the date appears.

Common problems and how to fix them

  • The result is a number. The date may be joined directly. Put the date reference inside TEXT and specify a format, such as TEXT(B2,"mmm d, yyyy"). This assumes B2 contains a true Excel date.
  • The result has no spaces. Excel does not insert spaces around joined pieces. Add them inside quoted text, for example " due ", and check whether a space is needed before or after the date.
  • The formula shows as text or does not calculate. Check that the formula begins with an equals sign and that the cell is not being treated as text. If the cell is formatted as Text, change it to General, then re-enter the formula. Also check for a leading apostrophe.
  • The date looks wrong or returns an unexpected result. Confirm the source cell contains a real date, not text that looks like one. Imported data can contain text dates, and their interpretation may depend on regional date conventions. Correct the source data before relying on the formatted output.
  • The month or day names differ by computer. Date names and interpretations can be affected by regional settings. Use a numeric, explicit format such as yyyy-mm-dd for machine-oriented labels, and agree on a convention when sharing files internationally.
  • The result does not update as expected. Verify that the formula refers to the intended cells and that calculation is enabled. In Microsoft 365, formulas normally recalculate automatically, but a workbook can be set to manual calculation.

One frequent misconception is that a date cell’s visible formatting will automatically carry over when it is concatenated. It will not: the formula creates a text result and needs an explicit format instruction. Another is that every date-looking entry is a date value. A pasted string such as 03/07/2026 may be text, so confirm the source before diagnosing the formula.

Use the result appropriately

A concatenated date is useful when the goal is readable text: a report heading, a status message, a printable label, or a filename component. It is less suitable as the only stored date in a dataset. Once the date is converted into a text string, Excel cannot treat that part of the string as an ordinary date for sorting, date filtering, or arithmetic without additional parsing.

Keep the original date in a separate column if you may need to calculate days between dates, filter by a date range, or build a chart. Create the joined wording in another column for display. This separation also makes it easier to change the sentence or date style later without altering the underlying data.

For a fixed report title that does not need to update, you could copy the formula result and use Paste Special > Values to replace it with text. Do this only when a static result is intended: pasted values will no longer change if the source date or label changes. In Excel for Mac, the Paste Special options are also available from the Edit menu or the Paste menu on the ribbon, though the exact shortcut differs by keyboard settings. For a formula-driven label that should stay current, leave the formula in place.

Frequently Asked Questions

How do I concatenate a date and text without getting a serial number?
Wrap the date cell in TEXT and choose a format, then join the result to text with &. For example, if A2 is a label and B2 is a date, use =A2&" "&TEXT(B2,"mmm d, yyyy").

Can I use CONCAT instead of the ampersand?
Yes. CONCAT can join text, separators, and a TEXT-formatted date. The important part is formatting the date with TEXT; changing the joining function does not remove the need for that step.

How do I include the weekday in the concatenated date?
Use a format code with dddd for the full weekday name or ddd for an abbreviation. Assuming B2 contains the date, =TEXT(B2,"dddd, mmmm d, yyyy") displays a full date with its weekday.

Can I concatenate a date and keep the result as a real date?
No. Joining a date with text creates a text string. Keep the original date in a separate cell for calculations and use the concatenated result only for display or output.

Why does my formula show the date as a number even though the cell looks correct?
The source cell’s number format controls its appearance on the worksheet, but concatenation uses the stored date value. Apply a format inside TEXT in the formula to create the intended date wording.

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.