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