To concatenate a date and text in Excel, convert the date to readable text with the TEXT function, then join it with the text using an ampersand. For example, with a date in A2 and a note in B2, enter =TEXT(A2,"mmmm d, yyyy")&" - "&B2 to return a result such as June 15, 2026 – Review.
Why dates need special treatment
Excel stores dates as serial numbers so it can sort them, calculate the number of days between them, and use them in date arithmetic. A cell may display June 15, 2026, because its number format tells Excel to show the stored value as a date. When a formula joins that value to text, the result becomes text, and Excel may use the underlying serial number rather than the date’s displayed appearance.
That is why a formula like =A2&" - "&B2 can produce a result resembling 46288 – Review instead of June 15, 2026 – Review. The exact serial number depends on the date. Applying a date format to the formula’s result cell will not fix this: the combined result is text, not a date value. Use TEXT around the date to specify how it should look before joining it to the other content.
The basic formula with TEXT and an ampersand
Suppose A2 contains June 15, 2026, as a real Excel date, and B2 contains Review. With the date in A2 and the note in B2, enter =TEXT(A2,"mmmm d, yyyy")&" - "&B2. The result is June 15, 2026 – Review. The ampersand joins each piece, while the hyphen and spaces inside quotation marks supply the separator.
To use it, select the cell where you want the combined result, type the formula, and press Enter. If you have a row of records, fill the formula down using the fill handle at the lower-right corner of the selected cell. Relative references will adjust as the formula moves: the next row will refer to A3 and B3, then A4 and B4, and so on. In Excel for Microsoft 365 on Windows, Mac, and the web, the formula syntax and basic method are the same, although regional settings can affect which argument separator Excel expects.
The TEXT function has two parts: the value to format and a format code in quotation marks. In this example, A2 is the value and mmmm d, yyyy is the format code. The ampersand can join more than two items, so you can add a fixed label, another cell, or punctuation to the same expression.
Choose a date format that suits the result
The format code controls the text produced for the date. Use uppercase M for months and lowercase m for minutes in time formats; in a date-only pattern, m or mm represents the month. Common date patterns include:
- mmm d, yyyy for Jun 15, 2026.
- mm/dd/yyyy for 06/15/2026.
- yyyy-mm-dd for 2026-06-15, a clear year-first style often useful in filenames and sortable labels.
- dddd, mmmm d for Monday, June 15.
With the date in A2 and a label in B2, use =TEXT(A2,"yyyy-mm-dd")&" — "&B2 when you want a year-first result such as 2026-06-15 — Review. The long dash is a literal character in the quoted text. You can replace it with a colon, comma, slash, or other separator that suits your document.
Format codes are not the same as the number format applied to A2’s cell. Changing A2’s appearance does not necessarily change the formula’s output; change the code inside TEXT to change the joined result. For example, a two-digit month may be useful for a compact label, while a spelled-out month is easier to read in a message. Make sure that the chosen pattern is unambiguous for your audience, particularly when dates such as 04/05/2026 could be interpreted as April 5 or May 4 in different regions.
Join several cells, labels, or fixed text
You can join more than one cell by adding another ampersand and reference. For example, say A2 contains a date, B2 contains a task, and C2 contains a department. With those values in A2:C2, enter =TEXT(A2,"mmm d, yyyy")&" | "&B2&" | "&C2. If the cells contain June 15, 2026, Review, and Sales, the result is Jun 15, 2026 | Review | Sales.
Fixed words must be enclosed in straight double quotation marks; cell references do not. To place a label before a date, with the date in A2, enter ="Due: "&TEXT(A2,"mmmm d, yyyy"). The result begins Due: followed by the formatted date. To add text after a date, put another ampersand and quoted text at the end. Spaces count as characters, so include them inside the quoted pieces wherever the output needs spacing.
For a list of cells, CONCAT can be easier to read than a long chain of ampersands, but it does not automatically add spaces or punctuation, and it does not preserve a date’s display format. With the date in A2 and the note in B2, enter =CONCAT(TEXT(A2,"mmm d, yyyy")," - ",B2). It returns Jun 15, 2026 – Review. The TEXT function is still necessary for a readable date; CONCAT only joins the supplied pieces.
Use TEXTJOIN when a separator repeats
TEXTJOIN is useful when you are combining multiple pieces with the same delimiter. Its arguments specify the delimiter, whether to ignore empty cells, and the values or range to join. It can keep formulas tidier when you have several fields and want a separator between each one.
With a date in A2, a task in B2, and a department in C2, enter =TEXTJOIN(" | ",TRUE,TEXT(A2,"mmm d, yyyy"),B2,C2). For June 15, 2026, Review, and Sales, the result is Jun 15, 2026 | Review | Sales. TRUE tells TEXTJOIN to ignore empty values among the items it joins. It does not eliminate the need to format the date with TEXT.
CONCAT and TEXTJOIN are available in current Microsoft 365 Excel. The ampersand approach is a simple choice for a small number of pieces and is also supported in older Excel versions. An older function named CONCATENATE remains in Excel for compatibility, but new formulas are usually easier to maintain with ampersands, CONCAT, or TEXTJOIN. Whatever joining method you choose, format dates explicitly when the result must show a particular date style.
Include times or calculate a date range
Excel stores a time as a fraction of a day alongside the date. If A2 contains both a date and a time, a date-only format code will omit the time from the joined text. Use a code that includes hours and minutes when both matter. With a date-time value in A2 and a status in B2, enter =TEXT(A2,"mmm d, yyyy h:mm AM/PM")&" - "&B2. A value for June 15, 2026 at 2:30 PM followed by Review produces Jun 15, 2026 2:30 PM – Review.
For a date range, suppose A2 is the start date and B2 is the end date. Enter =TEXT(A2,"mmm d")&" to "&TEXT(B2,"mmm d, yyyy") to show a range such as Jun 15 to Jun 18, 2026. Formatting both values separately lets you omit the year from the first date while retaining it at the end. This formula creates a label only; it does not calculate the number of days in the range.
What the joined result can and cannot do
A formula that combines a date with text returns text. That makes it useful for a report heading, an email-ready label, or a descriptive identifier, but the output is no longer a date that Excel can use directly for date calculations or chronological sorting. If you need both a readable label and a working date, keep the original date in its own column and create the combined text in another column.
The result will update when a referenced cell changes, as long as Excel is calculating formulas automatically. If you need to preserve the current wording as a fixed value, copy the formula results and use Paste Special > Values in Excel for Windows. On Mac, use Home > Paste > Paste Special > Values, or the Paste Special command available from the context menu. Check the pasted values before removing the source data, because values-only pasting replaces formulas with their current results.
For a reusable template, keep the date and text in separate input columns and make the combined field a formula column. That structure is easier to sort, filter, edit, and audit than storing all information in one manually typed field. If you need to sort by date, sort on the original date column rather than on the combined text, where month names or differing formats can produce an unexpected order.
Common problems and practical fixes
- The result shows a number. Wrap the date reference in TEXT and specify a date format, rather than relying on the source cell’s appearance.
- The result has no spaces. Add spaces inside quoted text, such as
" - ", or include a space in a fixed label. - The date is wrong or looks swapped. Check that the source cell contains a real date and that the format code matches your intended month-day order. Text that merely looks like a date may not be interpreted consistently.
- The formula displays instead of calculating. Confirm that the cell is not formatted as Text, then re-enter the formula. Also check that it begins with an equals sign and that Show Formulas is not enabled.
- Excel reports a formula error after pasting. Regional settings may require semicolons instead of commas between function arguments. The examples here use commas, as in standard English-language formula syntax; use the separator your Excel installation expects.
When a cell contains a date stored as text, TEXT may not behave as expected because Excel cannot format text in the same way it formats a date serial value. Convert or correct the source data first, and verify a few rows before filling a formula down a large table. Also check for blank date cells: a blank reference can produce an unwanted date-like value or an incomplete label, depending on the formula and source. If blanks are common, decide whether the output should remain empty or show a message, then build that rule into the formula.
Frequently Asked Questions
Can I concatenate a date and text without getting a serial number?
Yes. Use TEXT around the date reference and choose a format code, then join it to text with &, CONCAT, or TEXTJOIN. A plain reference to a date may expose its underlying serial number.
Does changing the date cell’s format change the concatenated result?
Not reliably. The combined formula creates text, so specify the desired appearance inside TEXT. Changing the source cell’s number format affects how that cell is displayed, not the format code in your formula.
Can the combined result still be sorted as a date?
No, not as a true date value. Keep the date in a separate date column for date-based sorting and calculations, and use the concatenated text column only for display.
What is the difference between CONCAT and TEXTJOIN?
CONCAT joins supplied values without inserting a separator. TEXTJOIN adds a chosen delimiter between items and can ignore empty values. Neither function formats a date automatically, so use TEXT for readable dates in either formula.
Will the formula work in Excel for Mac or Excel for the web?
The same basic functions and ampersand method work in current Excel for Mac and Excel for the web. Formula argument separators can vary with regional settings, but the date-formatting idea remains the same.
Related
- Can You Delete Duplicates in Excel? Methods and Tips
- Delete Multiple Tabs in Excel at Once: How It Works
- Can You Change Keyboard Shortcuts in Excel?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Remove Duplicates From a List AutomaticallyWith values in A2:A20, enter =UNIQUE(A2:A20) in an empty cell to return one copy of each distinct value.…
- Excel SUMIF Not Blank: Sum Values When Cells Have DataWith the cells to check in A2:A10 and the numbers to add in B2:B10, use =SUMIF(A2:A10,"<>",B2:B10) to sum…
- Count Unique Values in Excel with a Simple FormulaTo count distinct, nonblank entries in a column in Microsoft 365, enter =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) in an empty cell, replacing…
- Excel CONCAT Formula: Combine Two Columns With a SpaceTo combine two columns in Excel, enter =CONCAT(A2," ",B2) in a blank cell, replacing A2 and B2 with…
- How to Filter by Color in ExcelTo filter by color in Excel for Microsoft 365 on Windows, turn on filters for your data, open…
- VLOOKUP Excel Extended Range: How to Expand ItTo extend a VLOOKUP range, enlarge its table_array so it includes the added rows, or convert the source…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.