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/
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!
I love your style of training. Direct and so clear. Also, you have great taste in formatting.
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.
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
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:
ua-cam.com/video/jEr3uj1ljQ8/v-deo.html
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!
I loved your tutorial! It was very well explained and very easy to understand, exactly what I was looking for!
Really I was enjoyed, no boring and clearly understood. Thank you so much.☺
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!
An incredible video, thanks Mr. Mourad for this detailed tutorial.
You're welcome Vana
So many terrible videos on UA-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
ua-cam.com/video/GK29EBbyjXo/v-deo.html
Hope you subscribe to my channel.
Great explanation, never thought it could be done this way...simple use of your own formula ...thanks a lot 😊😊😊
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
You really are a nice teacher!! No words to describe.
Great, useful and nicely explained.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟
Your tutoring is such a blessing. Thank you, Sir
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
Oh great, thank you for your good explanation, this is well prepared video.
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
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 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).
Excellent video. Very useful. Thank you.
God bless, I am fulfilled creating this Calendar by myself on your instructions. You are good!
Great Explanation! Thanks!
One of the best channels on the UA-cam!
I truly appreciate your comment
Thanks a lot. Excellent to my Excel Teacher.
Best calendar creation tutorial on youtube. Tyvm!
Wow, thank you!
This is another useful tool that displays the Excel genius of Nabil.
Thank you
Sir ! You are the best Excel teacher in Entire UA-cam channel..
Great you liked it
Show your support to my channel by sharing the video and watching my other videos
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
Very useful function and easy to mind explanation..
تحية لك من عُمان بلاد الأمن والأمان..
Thank you for the nice comment... Please share with your friends on Social Media
Its a very informative and detailed presentation on making a calendar. I appreciate the Teacher efforts.
Glad you found it useful
Namasté and Great Day! This was a fantastic tutorial! You rock!
Thank you so much for this great tutorial. Very useful. Do you have a tutorial on how to add events on the calendar automatically?
This is great and informative. Thank you, very much!
Thank You
Sir, what a fabulous way to teach and express ,not many have this . Thanks a Ton
Thanks and welcome
Excellent tutorial, Thank you Mr. Nabil.
Brillaint Video. I could create a calendar in less than 20 minutes. You are a great tutor
Glad it was helpful!
This is just beautiful. thank you so much
You are so welcome!
Very helpful and informative. Thanks Nabil.
Thank you for the encouraging feedback
Great work man. Works perfectly
Thank you for the information. Excellent job.
Brilliant explanation, thanks!
Thank you for the motivating comment.
Please share on your Social Media
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:
ua-cam.com/video/GK29EBbyjXo/v-deo.html
Thank you!
Very well done thank you for sharing.
Glad you liked it
I love this training video, wanting more, thanks
Thank you Sir !
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)
Great stuff 👍 Packed full of great tips and formulas
Great to hear!
Very nicely and easy way to teach with login behind all formula used and objectivity....Great Sir..
Thanks and welcome
Super very easy technik sir by you...
Thanks and welcome
Thanks a lot Sir.
Really great presentation.
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!
Thank you for the video.. very helpful !! Add a one more function weeknum 🤗
Thanks for watching
Such a nice tutorial.
Thank you Jawad.
I'm glad you liked it. Share it with your friends.
Did you watch my other tutorials?
Very good, nicely done.
Thank you very much!
Top man!
Easy to do with a good teacher. 🎉 congrats. It’s just missing make a complete calendar, with all months.
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.
This is a perfect video. But I have a questions. For example, I want to select any cell. How i know "which choosed"
Fantabulous...
Superb...sir..
Thank you very much.
Most welcome
very useful and great idea sir .. thanks you very much
Clear instructions, I learned a lot from this video. Thank you very much!
Stay tuned... The best is yet to come
Thank you I made mine.
Thanks sir its really helpful.
I'm glad you liked it
Very nice video for learning
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
Fantastic tutorial.
Thank You
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.
Great video
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:
ua-cam.com/video/GK29EBbyjXo/v-deo.html
VERY NICE... SHUKRAN ..MOURAD
Glad you liked it
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
superb knowledge !!!!!!
Thank you
Thank you!! Is there a way to add appointments or activities? Do you have a video on it??
Not yet!
Hello, is there anyway to include below column with a comment? thank you.
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?
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?
Thanks alot sir
You're welcome Sunil
nice video
excellent video
Glad you liked it!
here is the file:
1drv.ms/x/s!AkP-Crku8UuBuHZiSiS4Aw5ZmdhI?e=Rlj4Ek
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
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.
Please publish how to monitor the loan accounts, sanctioned on different dates, at different rates of interest, for a different period.
Very super video
Thank you
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.
Verry good
Sir How did you make weekday sheet?
Execellent
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.
Is there a way of showing three or four months?
Pls explain once again iam getting error using formula like =star-(weekday CTC... We getting error
great
alright i get it officeinstructor..sir how about the date today automatically from the date today?
Same thing like the video
Nice