Create a Date Range

HomeExcel FormulasCreate a Date Range

While working in data where you have dates, you might have to create a range of dates. A range is something that has a start date and an end date.

In this tutorial, you will learn to create a date range.

Create a Date Range Starting from Today

Now let’s say you want to create a date range of seven days starting from today.

In the following example, we have today’s date in cell A1 which we have got by using today’s function.

date-range-starting-from-today

=A1+7

To create a date range, follow these simple steps:

  1. Enter the “=” in the cell B1, or any other cell.
  2. Refer to the cell A1, or where you have the starting date of the range.
  3. Use the “+” sign to add days in the today’s date.
  4. Specify the number of days you want to add in today’s date.
create-a-date-range

Create a Date Range in a Single Cell

Let’s go a little further and create a date range in a single cell.

And for this, we need to combine both starting date and ending date in a single cell.

But the problem is when you try to combine two dates within a single cell it returns something like below.

create-a-date-range-in-a-single-cell

Now to overcome this problem we need to use the TEXT function to convert dates into text and then combine them as a range of dates.

The formula would be something like below.

text-function-for-date-range

=TEXT(A1,”dd/mmm/yy”)&” — “&TEXT(B1,”dd/mmm/yy”)

Now as you can see, we have a range of dates in cell C1 starting from 8-Feb-22 to 15-Feb-22.

And if you want to create a range of dates in a single cell, you can use the following formula.

=TEXT(TODAY(),”dd/mmm/yy”)&” — “&TEXT(A1+7,”dd/mmm/yy”)

The part about using the TEXT function, you can change the format of the date the way you want.