="text"&TEXT(date,format)

Related formulas

Get day name from date

Get month name from date

Convert date to text

Join cells with comma

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")

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:

The date is 42887

To control the date format, we 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.

="text"&TEXT(date,format)