Forum Discussion
Copy dates from another sheet
Hi! I have a spreadsheet to compile all of my work hours and every sunday, I add a new "blank week". I'd like to know if there's a way to create a formula that continues the dates automatically when ...
Alternatively, you could just insert four empty rows above the weekly template. Then, in the first date cell (that will then be B5) you enter:
=B1+1
In cell B6 you enter:
=B5+1
... and copy the cell down to the last day of the week.
Every week you can then copy rows 5 to 14 from the template and paste them directly under the previous week in the cumulative sheet for 2020.