Date Range Series

Occasional Visitor

What do I do to drag a date range down by row to continue the series?

 

i.e. 

1/1/2021 - 1/7/2021

*Then whatever action I need to do to result in subsequent rows being:

1/8/2021 - 1/14/2021

1/15/2021 - 1/21/2021

1/22/2021 - 1/28/2021

1/29/2021 - 2/4/2021

 

 

 

1 Reply

@hannahhoward 

I'd use two columns.

 

For example, enter the start date 1/1/2021 in A1.

In A2, enter the formula = A1+7

Fill or copy down from A2 as far as needed.

 

In B1, enter the formula =TEXT(A1,"m/d/yyyy")&" - "&TEXT(A1+6,"m/d/yyyy")

Fill or copy down from B2 to the end of the data.

 

You might hide column A now, if you wish.