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:

[seesterran]

Wow. Wow. Wow. You are an Excel-lent teacher! You explained very quickly and didn’t miss a step. (But, I’m so thankful that I was able to pause and rewind.) I love how you also taught keyboard shortcuts as you went. I wish I could give more than one thumbs up. 👍👍👍👍👍

[davidc]

So many terrible videos on YouTube. It was really nice watching your video, so clear and knowledgeable. Thanks for posting this!!!

[tushya]

THANK YOU SO MUCH, You can't believe how long I've been doing this manually, I really appreciate your style of tutoring as well, concise and to the point.

[danielgergely]

Wow!! Now that is a good tutorial. I have seen hundreds before, but this one is in the top 5 in my opinion. He not only explains what to type but also explains the logic behind it. Awesome job!!

[sanjayTECH]

Sir ! You are the best Excel teacher in Entire YouTube channel..

[milo-]

Was searching exactly for this. Never imagined that someone would have all of it in a single video, what I really needed. That too with such details. Thank you Nabil. You are a good teacher.

[hankgrimes]

This is one of the best videos I've seen. Clear explanations and formulas that WORK! Excellent job!

[simonbello]

God bless, I am fulfilled creating this Calendar by myself on your instructions. You are good!

[wliu]

What a brilliant video, this has helped me create my own version of a fiscal year calendar that I can reuse in the future!! Thank you!

[dalsheel]

Best calendar creation tutorial on youtube. Tyvm!

[explorgrande]

This is another useful tool that displays the Excel genius of Nabil.

[abersabeel]

One of the best channels on the YouTube!

[mat]

Brillaint Video. I could create a calendar in less than 20 minutes. You are a great tutor

[pravuchaudhary]

You really are a nice teacher!! No words to describe.

[SattaarEl]

Thank you Mr. Mourad! I was thinking about doing this myself for years for our meal calendars. What a comprehensive video tutorial! I am keeping it, and sharing.

[BenkiVasu]

Sir, what a fabulous way to teach and express, not many have this . Thanks a Ton

[agisz]

This is the really well explained tutorial. Thank you. I hope to see more.

[umairzubairsahiwal]

Its a very informative and detailed presentation on making a calendar. I appreciate the Teacher efforts.

[nickylove]

I love your style of training. Direct and so clear. Also, you have great taste in formatting.

[cwjr]

Thank you very much for the video! I was able to use the information to build a dynamic training calendar for my employer. Great information and very clearly explained.