Concatenate Date in Excel & Google Sheets

This tutorial will demonstrate how to concatenate a date with another string of text in Excel and Google Sheets.

Concatenate Date Main

Join Date with Text

If you attempt to concatenate (join) a date with text, the date will be displayed as a number:

<<update example   = b3 & b4    where b3 says “The date is: ”  and b4 is a date. show that the date formatting is not carried over>>

This is because Excel stores dates as serial numbers; when you join a date with text, the cell formatting is not carried over.

TEXT Function

The TEXT Function allows you to display a number as text with specified formatting.  You can use the TEXT Function to set date formatting.  Here’s an example with m/d/yyyy formatting:

Text MDYYY

Here is an example with MMMM D, YYYY formatting:

Full Date

Create Date Range

You can join together two dates to create a date range using two text functions:

 

Create Date Range

Notice that this maintains the date formatting.

By adding in IF Statements you can create a smarter formula that won’t display blank dates:

First Day Missing

or

SEC Day Missing

Concatenate Date in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Concatenate Date Google

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!