TrumpExcel's video: Creating Dynamic Monthly Calendar in Excel Interactive Calendar

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: https://swiy.io/7Ntt -------------------------------------- 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 - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1