=SEQUENCE(53,7,DATE(2022,1,1),1)
Sheets Tip 212: Single Formula Year Calendar
At the heart of today’s tip is the fantastic SEQUENCE function.
In a blank Google Sheet, enter this formula into cell A2:
=SEQUENCE(53,7,DATE(2022,1,1),1)
It outputs a year of dates across 7 columns!
Add the days of the week as a header row and you’re set.
Ben Collins shares a means of creating a year calendar: