Create a Dynamic Calendar in Excel For Any Month in Any Year
ฝัง
- เผยแพร่เมื่อ 9 ต.ค. 2018
- 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:
officeinstructor.com/public/
I love your style of training. Direct and so clear. Also, you have great taste in formatting.
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!
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.
This is the really well explained tutorial. Thank you. I hope to see more.
I loved your tutorial! It was very well explained and very easy to understand, exactly what I was looking for!
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.
You're welcome!
I have another tutorial about creating a Dynamic Calendar using Power Query. Check it out on my channel
You really are a nice teacher!! No words to describe.
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!!
Thank you so much for the nice comment.
I invite you to watch my latest tutorial by clicking on the link:
th-cam.com/video/jEr3uj1ljQ8/w-d-xo.html
This is one of the best videos I've seen. Clear explanations and formulas that WORK! Excellent job!
Stay tuned... The best is yet to come
God bless, I am fulfilled creating this Calendar by myself on your instructions. You are good!
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.
Glad I could help!
Really I was enjoyed, no boring and clearly understood. Thank you so much.☺
Your tutoring is such a blessing. Thank you, Sir
Best calendar creation tutorial on youtube. Tyvm!
Wow, thank you!
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. 👍👍👍👍👍
Thank you Rhonda
One of the best channels on the TH-cam!
I truly appreciate your comment
An incredible video, thanks Mr. Mourad for this detailed tutorial.
You're welcome Vana
Great explanation, never thought it could be done this way...simple use of your own formula ...thanks a lot 😊😊😊
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.
Thank you Miranda... Don't miss my new Tutorials... Since you mentioned "Meals" then watch the Pizza Tutorial
@@Officeinstructor Will do!
Great, useful and nicely explained.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟
Very clear and logical explanation, look forward to more videos especially Excel with words and Outlook, if possible.
Thank you... Did you watch my latest videos? awaiting your comments on them
This is another useful tool that displays the Excel genius of Nabil.
Thank you
Sir ! You are the best Excel teacher in Entire TH-cam channel..
Great you liked it
Show your support to my channel by sharing the video and watching my other videos
So many terrible videos on TH-cam. It was really nice watching your video, so clear and knowledgeable. Thanks for posting this!!!
You're very welcome David,
Here is a more recent video on creating a calendar with Power Query, don't miss it
th-cam.com/video/GK29EBbyjXo/w-d-xo.html
Hope you subscribe to my channel.
Thank you Mr. Mourad. Very clear explanation. This is a perfect video :-)
Thank you ... Did you watch my latest videos? would love to hear from you Matthias
Thank you for the information. Excellent job.
Sir, what a fabulous way to teach and express ,not many have this . Thanks a Ton
Thanks and welcome
Namasté and Great Day! This was a fantastic tutorial! You rock!
Excellent video. Very useful. Thank you.
Excellent pace of teaching with relevant visual content
Glad you liked it. Did you watch the newer version created by Power Query? Here it is:
th-cam.com/video/GK29EBbyjXo/w-d-xo.html
Oh great, thank you for your good explanation, this is well prepared video.
Brillaint Video. I could create a calendar in less than 20 minutes. You are a great tutor
Glad it was helpful!
Excellent tutorial, Thank you Mr. Nabil.
Its a very informative and detailed presentation on making a calendar. I appreciate the Teacher efforts.
Glad you found it useful
Thank you for this tutorial.
I made a small change. I just changed the date font size and the cells (conditional formatting) so that the grey in the previous and next month dates be in a lighter shade of grey and the numbers in those cells be light grey (that is a darker shade of grey than the cell colour). I made the changes to accommodate the dates to be seen by visually impaired people (aka: large print).
Great Explanation! Thanks!
Very useful function and easy to mind explanation..
تحية لك من عُمان بلاد الأمن والأمان..
Thank you for the nice comment... Please share with your friends on Social Media
Great work man. Works perfectly
I love this training video, wanting more, thanks
Clear instructions, I learned a lot from this video. Thank you very much!
Stay tuned... The best is yet to come
Thanks a lot. Excellent to my Excel Teacher.
This is great and informative. Thank you, very much!
Thank You
Great stuff 👍 Packed full of great tips and formulas
Great to hear!
Good video.
After I watched this video, I subscribed the channel.
Hopefully, all other videos also offer a lot of tips.
Great welcome to the OfficeInstructor Channel
The Best Is Yet to come
This is just beautiful. thank you so much
You are so welcome!
Really great presentation.
Brilliant explanation, thanks!
Thank you for the motivating comment.
Please share on your Social Media
Very helpful and informative. Thanks Nabil.
Thank you for the encouraging feedback
Very nicely and easy way to teach with login behind all formula used and objectivity....Great Sir..
Thanks and welcome
Very well done thank you for sharing.
Glad you liked it
Thank you Sir !
Thank you!
Fantastic tutorial.
Thank You
Thank you I made mine.
Thank you so much for this great tutorial. Very useful. Do you have a tutorial on how to add events on the calendar automatically?
very useful and great idea sir .. thanks you very much
Top man!
Thanks a lot Sir.
Such a nice tutorial.
Thank you Jawad.
I'm glad you liked it. Share it with your friends.
Did you watch my other tutorials?
Thank you for the video.. very helpful !! Add a one more function weeknum 🤗
Thanks for watching
Great video
Very good, nicely done.
Thank you very much!
Fantabulous...
Very nice video for learning
superb knowledge !!!!!!
Thank you
It is marvellous,
Thank you for the encouraging comment. By the way there is a more recent video for creating a calendar with Power Query, I encourage you to watch it. here is the link:
th-cam.com/video/GK29EBbyjXo/w-d-xo.html
Easy to do with a good teacher. 🎉 congrats. It’s just missing make a complete calendar, with all months.
Thank you for your fantastic video. Great explanation throughout.
Only problem I have is with the formula at the end in Conditional Formatting. I enter the formula as in the video but it always returns an error message stating "There's a problem with this formula. "
I can't understand why this is/any ideas?
Thanks again!
Thanks sir its really helpful.
I'm glad you liked it
Super very easy technik sir by you...
Thanks and welcome
Superb...sir..
Thank you very much.
Most welcome
Hello, is there anyway to include below column with a comment? thank you.
Verry good
VERY NICE... SHUKRAN ..MOURAD
Glad you liked it
Nicely explained, Thank you Mr.Nabil, please also show how can we add week to be displayed against the date
Just add a colum before the date and type this formula
=WEEKNUM(CELL_REFERENCE)
excellent video
Glad you liked it!
here is the file:
1drv.ms/x/s!AkP-Crku8UuBuHZiSiS4Aw5ZmdhI?e=Rlj4Ek
Well explain Sir! So my question is: How do you duplicate this to a 12-Months Calendar year with other events link to the cell in the calendar and other Conditional Formatting rules such as Holidays on the calendar of each month? Can you do a video about that if possible. Thanks in advance.
Execellent
This is a perfect video. But I have a questions. For example, I want to select any cell. How i know "which choosed"
To have number in D1 make the list for the month data validation 1 through 12 and provide the month name by custom number formatting.
Hello! Thank you for the video but I have a question. I am attempting to do this in a 5 or 6 day format, for example Monday - Friday, or Monday through Saturday. Could you explain how I could alter the formula's to accommodate this? It has to be very simple I am just missing it. I suppose I could just create the Sunday and ignore it or hide it.
Thanks again for the tutorial! Excel is so flexible.
Very comprehensive tutorial. I use a dynamic calendar template that is ready to use that I downloaded from someka. But this one is also nice. How can I get this one to download? Many thanks
nice video
Thanks alot sir
You're welcome Sunil
Thank You, Sir! Please explain how to create a date or calemdar picker in MS Excel.
Just watched and created the calendar per your video. I also downloaded your calendar. Down side is that February does not have 31 days. In fact all months have 31 days. Yet on screen with your video, it appears you added a step to make it work right but never corrected your download. Did I miss something?
Please publish how to monitor the loan accounts, sanctioned on different dates, at different rates of interest, for a different period.
Explanation is very great,,, thanks a lotSir .... I have a question please I have a monthly horizontal calendar, there are months with 31, 30 or 29 ... days.
How to hide blank cells completely when changing month.
Thank you
You may need to use an EOMONTH function
Very super video
Thank you
Thank you!! Is there a way to add appointments or activities? Do you have a video on it??
Not yet!
Hello sir, I tried it myself and I succeeded, thank you, now a question if I want to have and show only Tuesday and Thursday, how do I do it?
Nice
great
I´m not an Excel expert.
I have already created the Calendar You explained so well in this video. Now I'm trying to show national holidays in the calendar. I tied to use conditional forwarding rules to show national holiday like I have done before but this dose not seems to work in this case. Is it possible to show national holidays in this type of calendar ?
I have found solution for this using COUNTIF fuction and then create new conditional forwarding rule
Sir How did you make weekday sheet?
Pls explain once again iam getting error using formula like =star-(weekday CTC... We getting error
Is there a way of showing three or four months?
Excellent video. Dates and Vlookup comes in real handy!!.
In your tutorial your date in K1 is formatted as day, month, year and with dashes. 01-06-20. How did you do that?
All I came up with is month,day, year and with /. 06/01/20
Oh, and I downloaded your tutorial to use while watching the video. Everything went great up until I used the Start Label. I spent a couple of hours fooling with it. Your Finished spreadsheet also uses Start as a Label. So you can't use it elsewhere in the workbook. Every time I tried using it in my spread sheet, I ended up in the Finished one.
Anyway, thanks for the tutorial. I really learned a lot!!
CTRL + SHIFT + 3
Hmm. I'm using Excel 2013 and CTRL + SHIFT + 3 does not do anything. Could it be a version thing? @@Officeinstructor
Correction. I end up with 1-Jun-20. Sorry bout that.
Nice Dynamic Calendar. How can I automate the highlighting of important days like holidays,birthdays and the active day?
That's all conditional Formatting
@@Officeinstructor Thank you sir. How? I tried conditional formatting for active date it didn't work.
Well I got it for active day and for holidays I entered the date number in the conditional formatting.
How Do I add specific event dates onto the calendar? Thanks in advance!
That would be a totally different setup because you cannot enter tasks in the cells having formulas!
However you can add comments SHIFT + F2