Create a Dynamic Calendar in Excel For Any Month in Any Year
HTML-код
- Опубликовано: 22 авг 2024
- 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:
officeinstruct...
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
So many terrible videos on RUclips. 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
ruclips.net/video/GK29EBbyjXo/видео.html
Hope you subscribe to my channel.
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!
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!
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:
ruclips.net/video/jEr3uj1ljQ8/видео.html
God bless, I am fulfilled creating this Calendar by myself on your instructions. You are good!
Sir ! You are the best Excel teacher in Entire RUclips channel..
Great you liked it
Show your support to my channel by sharing the video and watching my other videos
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
Brillaint Video. I could create a calendar in less than 20 minutes. You are a great tutor
Glad it was helpful!
This is the really well explained tutorial. Thank you. I hope to see more.
Its a very informative and detailed presentation on making a calendar. I appreciate the Teacher efforts.
Glad you found it useful
You really are a nice teacher!! No words to describe.
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!
Sir, what a fabulous way to teach and express ,not many have this . Thanks a Ton
Thanks and welcome
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.
Best calendar creation tutorial on youtube. Tyvm!
Wow, thank you!
This is another useful tool that displays the Excel genius of Nabil.
Thank you
Very useful function and easy to mind explanation..
تحية لك من عُمان بلاد الأمن والأمان..
Thank you for the nice comment... Please share with your friends on Social Media
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).
I love your style of training. Direct and so clear. Also, you have great taste in formatting.
One of the best channels on the RUclips!
I truly appreciate your comment
Very nicely and easy way to teach with login behind all formula used and objectivity....Great Sir..
Thanks and welcome
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:
ruclips.net/video/GK29EBbyjXo/видео.html
Great explanation, never thought it could be done this way...simple use of your own formula ...thanks a lot 😊😊😊
Easy to do with a good teacher. 🎉 congrats. It’s just missing make a complete calendar, with all months.
Great stuff 👍 Packed full of great tips and formulas
Great to hear!
Your tutoring is such a blessing. Thank you, Sir
Thank you for the information. Excellent job.
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
Thank you for the video.. very helpful !! Add a one more function weeknum 🤗
Thanks for watching
I love this training video, wanting more, thanks
An incredible video, thanks Mr. Mourad for this detailed tutorial.
You're welcome Vana
Namasté and Great Day! This was a fantastic tutorial! You rock!
Clear instructions, I learned a lot from this video. Thank you very much!
Stay tuned... The best is yet to come
Excellent tutorial, Thank you Mr. Nabil.
Great, useful and nicely explained.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟
I loved your tutorial! It was very well explained and very easy to understand, exactly what I was looking for!
Very good, nicely done.
Thank you very much!
Really great presentation.
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
Super very easy technik sir by you...
Thanks and welcome
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.
This is just beautiful. thank you so much
You are so welcome!
Superb...sir..
Thank you very much.
Most welcome
Really I was enjoyed, no boring and clearly understood. Thank you so much.☺
Fantastic tutorial.
Thank You
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?
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:
ruclips.net/video/GK29EBbyjXo/видео.html
Oh great, thank you for your good explanation, this is well prepared video.
very useful and great idea sir .. thanks you very much
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)
Very helpful and informative. Thanks Nabil.
Thank you for the encouraging feedback
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
Thank you I made mine.
This is great and informative. Thank you, very much!
Thank You
Excellent video. Very useful. Thank you.
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
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?
Very well done thank you for sharing.
Glad you liked it
VERY NICE... SHUKRAN ..MOURAD
Glad you liked it
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
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 so much for this great tutorial. Very useful. Do you have a tutorial on how to add events on the calendar automatically?
nice video
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
The concept of making calender is not correct..as It is showing 30 and 31 date for the February month also.. Check your calendar for the feb month...
Thank You, Sir! Please explain how to create a date or calemdar picker in MS Excel.
Execellent
Very super video
Thank you
Great video
Great work man. Works perfectly
Great Explanation! Thanks!
Thanks a lot. Excellent to my Excel Teacher.
Brilliant explanation, thanks!
Thank you for the motivating comment.
Please share on your Social Media
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.
Please publish how to monitor the loan accounts, sanctioned on different dates, at different rates of interest, for a different period.
Thank you!! Is there a way to add appointments or activities? Do you have a video on it??
Not yet!
Fantabulous...
superb knowledge !!!!!!
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.
excellent video
Glad you liked it!
here is the file:
1drv.ms/x/s!AkP-Crku8UuBuHZiSiS4Aw5ZmdhI?e=Rlj4Ek
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!
Verry good
Thanks sir its really helpful.
I'm glad you liked it
Thanks a lot Sir.
Very nice video for learning
Thank you Sir !
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.
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.
iam watching aug 2020 what a coincidence
Hope you enjoy it
This is a perfect video. But I have a questions. For example, I want to select any cell. How i know "which choosed"
How do you color cell value based on the value of pivot table
That's conditional Formatting
Thanks alot sir
You're welcome Sunil
alright i get it officeinstructor..sir how about the date today automatically from the date today?
Same thing like the video
It’s very useful but I have a problem how to add information to the date
Let say I need to do a training each Monday so how am going to add that to the dynamic sheet?
Hi Waleed, I understand your concern but I cannot add TWO different contents (Typing Text + Having a dynamic Formula) in the same exact cell. So to make it look like an Outlook Calendar that requires a whole different setup.
I invite you to watch my latest tutorial "Valentine's Chart" and looking forward to reading your comments...Salam
Officeinstructor thanks can you help me as am trying to do a training for 019 each Monday and Thursday
So why don't you use Conditional formatting for these 2 days?
However if you want to have text corresponding to each day in the dynamic calendar, Then after doing everything as you learned in my tutorial, add a New worksheet and you need to adjust column widths and Row heights in a way that you 3 cells appearing as one (2 columns & 2 rows. The cell in the upper right = a cell in the dynamic calendar in the same relative position, while the remaining 3 cells (one in the top row & 2 in the next row will be all merged together and you get a Dynamic calendar with Outlook functionality.
I can't explain more in a comment... May be I create a video on that in the future.
Officeinstructor thanks but am lost, ;( can I get your email and email you the thing that I want done so you can help me, please.
@@Officeinstructor Have you created this video yet?
Is there a way to have the Month Change Color Automatically based on the Month?
Conditional formatting
Hello, is there anyway to include below column with a comment? thank you.
Nice