This is very helpful thank you! If you have two list of activities and have put them into the calendar in different colors, when both activities occur on the same day only one color shows on the calendar so the other activity could be missed if you don’t refer to the list on the first tab. Is there a way to show both on the same day in the calendar? Thank you.
Good correction, Starting from the Dynamic Calendar for 2020 version in Excel (*** Happy New Year ***). Also encountered a problem, largely solved in this video. With Conditional Formating I used the following formula during the holidays for the month of January, adjusting for the other months. $ E $ 8 = month number. = MONTH (C11) $ E $ 8 (MATCH (C11; Date; 0)) Set this as a second option! Again I have adapted the sheet to my wishes, thank you for the first layout. Also worksheet supplemented with week numbers / first day of the week Monday or Sunday / second language / holiday dates in addition to the calendar / logo with link. Thanks again
Very thorough tutorial. I use a ready to use dynamic calendar template I downloaded from someka. But this one also looks good. How can I download this one? Thank you
Hi great video, unfortunately I have an issue where the date for the activities are showing incorrectly on the calendar for example: I have an activity for 05/05/2022 but it is showing on the calendar as 04/05/2022, a day early. What would solve this please?
I have tried to copy yr program but when I try to add the activities dates, they only appear in OCT, NOV & DEC and are not just the activities for those months, can you guide me to the error of my ways please Nick
Dear Sir, It was vey helpful. But a problem is require to solve. After the Holidays activities conditional formating the 2nd April highlihted in both the months March and April. How to create it in only April. Please support.
Thanks for your appreciation! Keep month Conditional formatting on top in list and Holiday formatting after that in condition formatting window. Tick 'Stop If True' against the first conditional formatting.
I started working on this sheet and when I started copying the extra calendars and adding the conditional formatting, they all mark as grey… why is it not working?? I have redone it many times and and the whole calendar is marking grey…
If Voice is louder, crisp to the point would be better. Video could be sharp. In the activities list date upto 23 Dec was chosen under conditional formula "match", but to show dynamic, below 23 Dec date it was entered 23 Jan and reflects the same as green color in calendar. How it is possible without adding 23 Jan in the match range to make it dynamic.....
This is very helpful for me.with your help I prepared training calendar for next 3 years.Thank you so much
I am so glad I saw this. So many youtupe clips about how to... and they just grap a template.
Thanks a million.
Best Video.. having issue to create Event color and not applying Match formula in last date
This is very helpful thank you! If you have two list of activities and have put them into the calendar in different colors, when both activities occur on the same day only one color shows on the calendar so the other activity could be missed if you don’t refer to the list on the first tab. Is there a way to show both on the same day in the calendar? Thank you.
Good correction,
Starting from the Dynamic Calendar for 2020 version in Excel (*** Happy New Year ***). Also encountered a problem, largely solved in this video.
With Conditional Formating I used the following formula during the holidays for the month of January, adjusting for the other months.
$ E $ 8 = month number.
= MONTH (C11) $ E $ 8 (MATCH (C11; Date; 0))
Set this as a second option!
Again I have adapted the sheet to my wishes, thank you for the first layout.
Also worksheet supplemented with week numbers / first day of the week Monday or Sunday / second language / holiday dates in addition to the calendar / logo with link.
Thanks again
Very thorough tutorial. I use a ready to use dynamic calendar template I downloaded from someka. But this one also looks good. How can I download this one? Thank you
Very cool, thank you!
Hi great video, unfortunately I have an issue where the date for the activities are showing incorrectly on the calendar for example: I have an activity for 05/05/2022 but it is showing on the calendar as 04/05/2022, a day early. What would solve this please?
cool bro.. thanks a lot 😊👍
This is amazing! Thanks. On the template though it’s 2020, 2021 and it skips 2022. Possible to get a template that includes year 2022?
Very nice 👌
This is amazing. Thank you so much
Thanks for your feedback!
Great
how to and replicate/ dupicate funcstions like one you did to january?
Thanks
This is fabulous, great tool! How would one export to Google Sheets so the formulas still work?
Follow the same tutorial in Google sheets and it should work fine. As formulas are similar for both the spreadsheet.
nice and useful can we have tool tip showing the activity
Thanks for your appreciation! Good idea. Will post a short video on that.
@@thedatalabs thanks bro
wish u all the best..
@@thedatalabs where can i find that video?
damn you are so amazing... i just keep saying w0w...
Thanks for your kind words!
this is just what I need, the link to download does not work though?
What if there are two activities on same day, how to highlight on that same calendar?
I have tried to copy yr program but when I try to add the activities dates, they only appear in OCT, NOV & DEC and are not just the activities for those months, can you guide me to the error of my ways please
Nick
Hello I am also having the same issue, help please!
Dear Sir, It was vey helpful. But a problem is require to solve. After the Holidays activities conditional formating the 2nd April highlihted in both the months March and April. How to create it in only April. Please support.
Thanks for your appreciation! Keep month Conditional formatting on top in list and Holiday formatting after that in condition formatting window. Tick 'Stop If True' against the first conditional formatting.
I started working on this sheet and when I started copying the extra calendars and adding the conditional formatting, they all mark as grey… why is it not working?? I have redone it many times and and the whole calendar is marking grey…
Anyone know how to make the dates that spill over the months not highlight for holidays? Thank you
Dunno why it doesn't work from me. I followed step by step, but in the end, no dates highlighted based on the activity sheet. No idea what I missed
Hi.same happed to me. Do you figure out that?
Please make for 2023 calendar
With Indian holiday
Which shortcut key did you used @ 22:45?
It's ALT + O + D
why do you have your calendars start with Monday being the first day of the week.
please 2023 ka dijiye na
How to replicate?
If Voice is louder, crisp to the point would be better. Video could be sharp.
In the activities list date upto 23 Dec was chosen under conditional formula "match", but to show dynamic, below 23 Dec date it was entered 23 Jan and reflects the same as green color in calendar. How it is possible without adding 23 Jan in the match range to make it dynamic.....
Entire range was selected in the Activity list tab
It's not working
31 minutes
too much ads in this video...
You waste a lot of time drawing and coloring cells.