A step by step tutorial to create a dynamic annual/yearly calendar in Excel. The calendar will work for any year.

In a previous video, I presented the 2019 Excel Calendar template
[ Ссылка ]

Download template from [ Ссылка ]

There were 19 calendar designs in that free template.

In this video, we take a simpler version of one of the 19 designs and build step by step.


Overview of Steps:

1. Set up the calendar window
2. Set up Year Input
3. Create Month Headers
4. Create weekday headers
5. Create dates of year Formula
6. Create week number in Month
7. Create a Lookup key by concatenating Month, Week Number in Month and Weekday with spaces in between
8. Extract each date on calendar

Functions used:
INDEX, MATCH, CONCATENATE, WEEKNUM, WEEKDAY, MONTH, DATE, EOMONTH, IFERROR


Social:
Subscribe to YouTube: [ Ссылка ]
Facebook: [ Ссылка ]

-~-~~-~~~-~~-~-
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel" [ Ссылка ]
-~-~~-~~~-~~-~-

свернуть