We can use the SEQUENCE function to create all the dates in any given year.įor example, =SEQUENCE(365,DATE(2023,1,1)) generates all the 365 dates in the year 2023. To generate the calendar, I am using the dynamic array functionality of Excel 2023. The calendar workbook has two main components.
0 Comments
Leave a Reply. |