Forum Discussion
Excel Daily Calendar
I need a daily calendar in Excel where each tab is a consecutive day of the year - Mon Jan 01 - Tue Jan 02 and so forth. Is there an easy formula to do this? Thanks!
1 Reply
Using 365
= SEQUENCE(365,1,DATE(yr,1,1))as a dynamic array or, with older versions (fill down, starting in row 4),
= DATE(yr,1,-3) + ROW()
