0

Let's say I have a sheet with this dataset:

Start Date      Number of Days   
3/1/2019        2

From this input set, I want to make the following transformation:

Date
3/1/2019
3/2/2019
3/3/2019

A new date, incremented by one day, is added to the column "Date" for the total amount (listed under Number of Days).

Here's another dataset:

Start Date      Number of Weeks
3/1/2019        2

In this case, the resulting array should be:

Date
3/1/2019
3/8/2019
3/15/2019
  • Welcome. What is the question? – Rubén Nov 19 at 23:55
1
Start Date      Number of Days   
3/1/2019        2

Assuming 3/1/2019 is cell A2 use the following formula =arrayformula(sequence(B2+1,1,0)+A2) and the result will be:

3/1/2019
3/2/2019
3/3/2019

If you want to do weeks a simple modification like this will give you the exact result you asked for:

=arrayformula(sequence(B2+1,1,0,7)+A2)

SEQUENCE

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.