Forum Discussion
Update a 52 week template to a new year
I have a spreadsheet that has 52 weeks, w/the end date each week being Friday. This goes from Jan - Dec and is used for employee PTO info. The only way I know how to make the dates update to the new ...
This may work for you (You could simply change the year as needed):
=LET(Jan,DATE(2023,1,1),Start,Jan+CHOOSE(WEEKDAY(Jan,2),4,3,2,1,0,6,5),SEQUENCE(52,,Start,7))If you have access to Lambda, the sheet level function would be even shorter. You'd simply provide the year:
=Rollover(2023)
Both options included in the attached workbook.