Creating Dynamic Monthly Calendar in Excel Interactive Calendar

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=o1V2Fdygajo

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-c... • ✅ 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/trumpexc... • #Excel #ExcelTips #ExcelTutorial

#############################

New on site