Create a Dynamic Calendar in Excel For Any Month in Any Year

In this tutorial you'll learn how to create a very useful Dynamic Calendar in Excel: For any Month in Any Year. You'll be able to switch from one month to another by using 2 drop list, and have formatting update on the fly. You'll learn about Dates and Date Math in Excel. Along the way we'll use VLOOKUP & IF functions as well.

You can download the Start and Finished version of this Project to follow along and then do the activity on your own, by clicking on the link:
https://officeinstructor.com/public/

• #education
• #dates
• #date_function
• #weekday_function
• #defined_name
• #if_function
• #vlookup_function
• #month_function
• #conditional_formatting
• #nabil_mourad
• #officeinstructor