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.
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. 👍👍👍👍👍
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, 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.
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.
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).
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.
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.
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
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
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 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
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!!
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 ?
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.
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?
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.
i do not need to do anything special for leap years. Follow the steps in the tutorial and your dynamic calendar will work for ANY Month in ANY Year (as the title says)
Please make sure the function in the upper left corner has THE BRACKETS like in minute 14:05 of my tutorial. These brackets were missing in the posted exercise file so I replaced the file.... It MUST work if you follow the video. try the new file (or create it by following the steps)
Please make sure the function in the upper left corner has THE BRACKETS like in minute 14:05 of my tutorial. These brackets were missing in the posted exercise file so I replaced the file.... It MUST work if you follow the video. try the new file (or create it by following the steps)
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
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.
God bless, I am fulfilled creating this Calendar by myself on your instructions. You are good!
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.
Brillaint Video. I could create a calendar in less than 20 minutes. You are a great tutor
Glad it was helpful!
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
Excellent tutorial, Thank you Mr. Nabil.
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
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
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
This is another useful tool that displays the Excel genius of Nabil.
Thank you
Sir, what a fabulous way to teach and express ,not many have this . Thanks a Ton
Thanks and welcome
You really are a nice teacher!! No words to describe.
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
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!
One of the best channels on the TH-cam!
I truly appreciate your comment
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!
Its a very informative and detailed presentation on making a calendar. I appreciate the Teacher efforts.
Glad you found it useful
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
Very nicely and easy way to teach with login behind all formula used and objectivity....Great Sir..
Thanks and welcome
This is the really well explained tutorial. Thank you. I hope to see more.
Your tutoring is such a blessing. Thank you, Sir
Namasté and Great Day! This was a fantastic tutorial! You rock!
I love this training video, wanting more, thanks
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).
Very useful function and easy to mind explanation..
تحية لك من عُمان بلاد الأمن والأمان..
Thank you for the nice comment... Please share with your friends on Social Media
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.
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 stuff 👍 Packed full of great tips and formulas
Great to hear!
I love your style of training. Direct and so clear. Also, you have great taste in formatting.
Really great presentation.
Super very easy technik sir by you...
Thanks and welcome
Thank you for the video.. very helpful !! Add a one more function weeknum 🤗
Thanks for watching
Great explanation, never thought it could be done this way...simple use of your own formula ...thanks a lot 😊😊😊
Superb...sir..
Thank you very much.
Most welcome
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
An incredible video, thanks Mr. Mourad for this detailed tutorial.
You're welcome Vana
Very good, nicely done.
Thank you very much!
very useful and great idea sir .. thanks you very much
Very helpful and informative. Thanks Nabil.
Thank you for the encouraging feedback
Great, useful and nicely explained.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟
Great work man. Works perfectly
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
Excellent video. Very useful. Thank you.
Easy to do with a good teacher. 🎉 congrats. It’s just missing make a complete calendar, with all months.
This is just beautiful. thank you so much
You are so welcome!
Fantastic tutorial.
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
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.
I loved your tutorial! It was very well explained and very easy to understand, exactly what I was looking for!
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 well done thank you for sharing.
Glad you liked it
Thank you!! Is there a way to add appointments or activities? Do you have a video on it??
Not yet!
Thank you so much for this great tutorial. Very useful. Do you have a tutorial on how to add events on the calendar automatically?
Really I was enjoyed, no boring and clearly understood. Thank you so much.☺
This is great and informative. Thank you, very much!
Thank You
Brilliant explanation, thanks!
Thank you for the motivating comment.
Please share on your Social Media
Clear instructions, I learned a lot from this video. Thank you very much!
Stay tuned... The best is yet to come
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)
Thank you I made mine.
Great Explanation! Thanks!
VERY NICE... SHUKRAN ..MOURAD
Glad you liked it
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!
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
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.
Oh great, thank you for your good explanation, this is well prepared 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
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?
Thank You, Sir! Please explain how to create a date or calemdar picker in MS Excel.
iam watching aug 2020 what a coincidence
Hope you enjoy it
Thanks a lot. Excellent to my Excel Teacher.
Great video
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 nice video for learning
Such a nice tutorial.
Thank you Jawad.
I'm glad you liked it. Share it with your friends.
Did you watch my other tutorials?
superb knowledge !!!!!!
Thank you
Thanks sir its really helpful.
I'm glad you liked it
nice video
Very super video
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.
Thanks a lot Sir.
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?
Fantabulous...
excellent video
Glad you liked it!
here is the file:
1drv.ms/x/s!AkP-Crku8UuBuHZiSiS4Aw5ZmdhI?e=Rlj4Ek
Please publish how to monitor the loan accounts, sanctioned on different dates, at different rates of interest, for a different period.
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.
Verry good
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.
Thank you Sir !
Thank you!
How do you color cell value based on the value of pivot table
That's conditional Formatting
Thanks alot sir
You're welcome Sunil
This is a perfect video. But I have a questions. For example, I want to select any cell. How i know "which choosed"
alright i get it officeinstructor..sir how about the date today automatically from the date today?
Same thing like the video
Is there a way to have the Month Change Color Automatically based on the Month?
Conditional formatting
Great work !!! and how do you take care of leap years
i do not need to do anything special for leap years. Follow the steps in the tutorial and your dynamic calendar will work for ANY Month in ANY Year (as the title says)
@@Officeinstructor I don't think it works for all years and months. Check for even October 11, 2018....and see the day it gives u?
Please make sure the function in the upper left corner has THE BRACKETS like in minute 14:05 of my tutorial. These brackets were missing in the posted exercise file so I replaced the file.... It MUST work if you follow the video.
try the new file (or create it by following the steps)
Please make sure the function in the upper left corner has THE BRACKETS like in minute 14:05 of my tutorial. These brackets were missing in the posted exercise file so I replaced the file.... It MUST work if you follow the video.
try the new file (or create it by following the steps)
Great....it works!!!!
Hello, is there anyway to include below column with a comment? thank you.
Nice
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?
I NEED THIS FILE