Exceljet

Quick, clean, and to the point

Join date and text

Excel formula: Join date and text
Generic formula 
="text"&TEXT(date,format)
Summary 

To join a date with text, you can use concatenation with the TEXT function to control the date format. In the example shown, the formula in E4 is:

="The date is "&TEXT(B4,"dddd, mmmm yyyy")
Explanation 

The core of this formula is concatenation using the ampersand (&) operator:

="The date is"&date

However, if you simply join a date with text and don't control the date format, the date will revert to it's raw serial number format, and the result will look like this:

"The date is 42887".

To control the date format, use the TEXT function, which is designed to convert a number into text using a specified number format. This article shows a list of codes you can can use for date formats.

Author 
Dave Bruns
Related formulas 
Excel formula: Get day name from date
Get day name from date
In this example, the goal is to get the day name (i.e. Monday, Tuesday, Wednesday, etc.) from a given date. There are several ways to go about this in Excel, depending on your needs. This article explains three approaches: Display date with a custom...
Excel formula: Get month name from date
Get month name from date
In this example, the goal is to get and display the month name from any given date. There are several ways to go about this in Excel, depending on whether you want to extract the month name as text, or just display a valid Excel using the month name...
Excel formula: Convert date to text
Convert date to text
Dates and times in Excel are stored as serial numbers and converted to human readable values on the fly using number formats. When you enter a date in Excel, you can apply a number format to display that date as you like. In a similar way, the TEXT...
Excel formula: Join cells with comma
Join cells with comma
Working from the inside out, the formula first joins the values the 5 cells to the left using the concatenation operator (&) and a single space between each value: B5 & " " & C5 & " " & D5 & " "...
Related functions 
Excel TEXT function
Excel TEXT Function

The Excel TEXT function returns a number in a given number format, as text. You can use the TEXT function to embed formatted numbers inside text.

Related courses 
Core Formula

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.