In this video, I will show you the exact steps to create an interactive monthly calendar in Excel.

The calendar automatically updates as soon as you change the year value or the month value. And it also highlights all the dates that are holidays.

This dynamic monthly calendar uses some simple formulas, drop-down lists, and conditional formatting to get the work done.

✅ Download File: [ Ссылка ]

--------------------------------------

The formula for Older Versions of Excel (enter this formula in cell D5 and copy-paste for all the other cells in the grid)

=IF(MONTH(DATE($B$1,MATCH($B$2,'Month Names'!$A$1:$A$12,0),1)+(ROW()-5)*7+COLUMN()-3-WEEKDAY(DATE($B$1,MATCH($B$2,'Month Names'!$A$1:$A$12,0),1),2))=MATCH($B$2,'Month Names'!$A$1:$A$12,0),DATE($B$1,MATCH($B$2,'Month Names'!$A$1:$A$12,0),1)+(ROW()-5)*7+COLUMN()-3-WEEKDAY(DATE($B$1,MATCH($B$2,'Month Names'!$A$1:$A$12,0),1),2),"")

---------------------------------------

00:00 Intro
01:10 Making the Dynamic Monthly Calendar
01:50 Creating the Drop Down to show Month Names
02:36 Making a Dynamic Title for the Calendar
03:48 Formulas to Create an Interactive Excel Calendar
13:25 Highlighting Holidays in the Monthly Calendar

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - [ Ссылка ]

✅ Free Excel Course (Basic to Advanced) - [ Ссылка ]
✅ Free Dashboard Course - [ Ссылка ]
✅ Free VBA course - [ Ссылка ]
✅ Free Power Query Course - [ Ссылка ]
✅ Best Excel Books: [ Ссылка ]

Subscribe to get awesome Excel Tips every week: [ Ссылка ]

#Excel #ExcelTips #ExcelTutorial

свернуть