Quick, clean, and to the point

Join date and text

Excel formula: Join date and text
Generic formula 

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

How this formula works

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.

Dave Bruns

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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables