How to Make Fully Dynamic Employee Engagement Calendar for 2020 in Excel

Подписаться 129 тыс.

Просмотров 57 тыс.

50% 1

How to Make Fully Dynamic Employee Engagement Calendar for 2020 in Excel
In this video, we will create a fully automated employee engagement calendar for 2020. With the Help of Match, Weekday and Month functions, we will create a dynamic calendar and highlight the dates with conditional formatting. This template is very easy to create.
#EmployeeEngagementCalendar #TheDataLabs
Please follow the below link to download the Excel files (automated form ) used in this video.
thedatalabs.or...
Please visit our website www.thedatalabs.org
Please contact us on info@thedatalabs.org
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 51

@karthikjeevanandham6426 Год назад

This is very helpful for me.with your help I prepared training calendar for next 3 years.Thank you so much

@bigfatplanet 3 года назад

I am so glad I saw this. So many youtupe clips about how to... and they just grap a template. Thanks a million.

@daniellemarie9624 3 года назад

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.

@SABAZAIDI-q2p 11 месяцев назад

Best Video.. having issue to create Event color and not applying Match formula in last date

@davehansel9715 Год назад

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

@fisherman1202 3 года назад

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?

@jordantocknell4272 2 года назад

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?

@jmschroen-hendriks4542 4 года назад

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

@brendanstapleton9281 2 года назад

This is fabulous, great tool! How would one export to Google Sheets so the formulas still work?

@saurabhrai3135 Год назад

Follow the same tutorial in Google sheets and it should work fine. As formulas are similar for both the spreadsheet.

@thando7893 Год назад

this is just what I need, the link to download does not work though?

@valeiana3257 Год назад

What if there are two activities on same day, how to highlight on that same calendar?

@hunterbrave9916 Год назад

how to and replicate/ dupicate funcstions like one you did to january?

@craxkern1 4 года назад

cool bro.. thanks a lot 😊👍

@malindvats 4 года назад

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.

@thedatalabs 4 года назад

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.

@ngee4925 3 года назад

Very cool, thank you!

@balajisrinivasan8105 3 года назад

This is amazing. Thank you so much

@thedatalabs 3 года назад

Thanks for your feedback!

@prasadp9320 4 года назад

nice and useful can we have tool tip showing the activity

@thedatalabs 4 года назад

Thanks for your appreciation! Good idea. Will post a short video on that.

@prasadp9320 4 года назад

@@thedatalabs thanks bro wish u all the best..

@SamRahimi24 3 года назад

@@thedatalabs where can i find that video?

@rohitchalwadi704 2 года назад

Very nice 👌

@alializadeh8195 Год назад

Thanks

@islamic31399 2 года назад

Great

@nickwallace2659 4 года назад

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

@dylankeenan8828 2 года назад

Hello I am also having the same issue, help please!

@eesh711 2 года назад

Anyone know how to make the dates that spill over the months not highlight for holidays? Thank you

@991529jack 4 года назад

damn you are so amazing... i just keep saying w0w...

@thedatalabs 4 года назад

Thanks for your kind words!

@heidimedina9856 Год назад

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…

@NaveenCha 4 года назад

Which shortcut key did you used @ 22:45?

@thedatalabs 4 года назад

It's ALT + O + D

@jgoodwin27317 4 года назад

why do you have your calendars start with Monday being the first day of the week.

@angeljosephmartin-sq5dd Год назад

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

@dilinisewwandi8757 5 месяцев назад

Hi.same happed to me. Do you figure out that?

@deepakpatwa7157 Год назад

Please make for 2023 calendar

@deepakpatwa7157 Год назад

With Indian holiday

@bhavanasikarwar2682 2 года назад

How to replicate?

@murugavel1341 3 года назад

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.....

@saurabhrai3135 Год назад

Entire range was selected in the Activity list tab