Copy dates from another sheet

Yann906 

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.

Yann906 

In Week Template for Monday it could be formula

=DATE(2020,1,8)-WEEKDAY(DATE(2020,1,6)) + IF(ROW()>6,COUNTIFS($A$1:INDEX($A:$A,ROW()-1),"Dim",$B$1:INDEX($B:$B,ROW()-1),">1")*7,0 )

and

=B1+1

for next days. 

With that entire rows could be copy/pasted from Week Template to Year tab. Of course, better to keep 2020 as parameter, i.e. use as some cell value.

Please check in attached.