Create an annual Calendar in Excel - Step by Step Tutorial

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
   • 2019 Excel Calendar Template - Free D...  

Download template from https://indzara.com/2018/12/2019-exce...

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: http://www.youtube.com/user/theindzar...
Facebook:   / theindzara  

~-~~-~~~-~~-~
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel"    • Highlight events, weekends and holida...  
~-~~-~~~-~~-~