Create Date Range from Two Dates – Excel & Google Sheets

This tutorial will demonstrate how to create a date range from two dates.

Create Date Range Main Function

Date as Text

The first step to creating a date range from two dates is to convert a date to text using the TEXT Function.  The TEXT Function can convert dates into many different formats, but we’ll focus on two.

M/D/YYYY Format


AutoMacro - VBA Code Generator


mmmm d yyyy

Create Date Range

We can concatenate (join) two dates stored as text like this:

Create Date Range

This is useful for an event start and end date, but what if the second date is missing (ex. the event is only one day):

C3 Missing

To avoid the erroneous ” to ” if the second date is missing, we can use an If Statement to test if the second date exists before adding it to the string:

SEC Day Missing

You can also handle if the first date is missing:

First Day Missing

Create Date Range from Two Dates in Google Sheets

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

Create Date Range Google

Excel Practice Worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!