Forum Discussion

Yann906's avatar
Yann906
Copper Contributor
Jan 01, 2020

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 ...
excel
Excel on Mac
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 02, 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.

Resources