Free Dynamic Annual Calendar with Holiday and Control Panel

[@rajsahu1029]

Thanks!

[@PKAnExcelExpert]

Most welcome🙏

[@grijalvaescobedo158]

Excelente de lujo ING gracias por compartirlo y abrazos desde León Guanajuato 🇲🇽👏🤝

[@PKAnExcelExpert]

Gracias

[@MohAboAbdo]

Thank you very much, sir, for this excellent video, and for this simple and wonderful explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@kevinroche5480]

Really nice video, I learned some new techniques, thanks a lot.

[@PKAnExcelExpert]

Glad you enjoyed it!

[@pandharinathjoshi6565]

Superb sir Today I have seen sir💐🙏🙏

[@Leon-tw3nt]

Отличное видео! Ты очень талантливый парень)

[@PKAnExcelExpert]

Спасибо за ваш ценный отзыв

[@snipelite94]

I was expecting you to use the SEQUENCE function, but your solution is wonderfully layman-friendly as always 👍

[@PKAnExcelExpert]

Glad you like it! Also watch the dynamic calendar with Sequence function kzbin.info/www/bejne/poKZoHSup7F0pck

[@sujitsingha4153]

It is very informative and nice

[@PKAnExcelExpert]

Thanks for liking

[@MariCarmen-lj9nw]

Excellent! Thank you very much. I would like also to highlight the current day with a different colour. Can you help me with this?

[@klebersonmoreira1821]

Parabéns Mestre, obrigado por compartilhar. 🤜🇧🇷

[@PKAnExcelExpert]

muito bem-vindo

[@rafiacademichome6856]

Thanks , Very nice

[@PKAnExcelExpert]

Welcome 😊

[@jeraldthalaiva85]

Your videos are great. I am wondering if there is a way to set up a pop-up window that automatically shows the holiday when I click on a date in the calendar, such as Christmas or Pongal.

[@PKAnExcelExpert]

Yes, we can do that. I will try to create a video on this topic

[@jeraldthalaiva85]

@ Tq for your valuable comment ❤️❤️❤️❤️

[@xxbl00dbathxx]

Do you have video on how to create an annual, dynamic calendar that lists meeting dates similar to how you have it in outlook to plan future meetings?

[@khadimhussainmomin1315]

Great work

[@PKAnExcelExpert]

Thanks🙏

[@68111]

Wao...so nice sir really excellent

[@PKAnExcelExpert]

Thanks a lot

[@romlef526]

It's just fantastic

[@PKAnExcelExpert]

Thanks

[@aristoalexius]

One word: Awesome

[@PKAnExcelExpert]

Thanks

[@euniceliciousTV]

Thanks for sharing, I notice when the public holiday fall on the Weekend (If I choose Day of Week 1= Sun and Day of Week 2=Sat), Will not turn yellow. It will remain Grey, How Can we solve this issue when we still want to highlight the Public Holiday on weekend to overlap the light grey?

[@sujitsingha4153]

Priyendra one suggestion . Let's take an example if we want see when is the holiday and what is that for should reflect in calendar tab.

[@PKAnExcelExpert]

will try to incorporate in next version

[@ewertonmcdouglaslopes7359]

Really good. Any chance to add week number on this template?

[@PKAnExcelExpert]

Will add in next version

[@phoebedavis5526]

I like the calendar. I actually use someka dynamic calendar template but also would like to try this one. Where can I download this? Thank you

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@shyjumathew07]

Good one

[@PKAnExcelExpert]

Thanks🙏

[@ahmadaltayeb1983]

Thanks Sir

[@PKAnExcelExpert]

Most welcome🙏

[@diya2909]

Sir very awesome video like your all the videos, Sir can you add one drop down also, state wise, If user select any state ,then related to that selected state's holidays highlighted, if yes then please tell us how. Regards

[@ashutoshpatel19]

Dear sir please make worksheet complier in VBA we have need your all video is beautiful and dinamic.

[@PKAnExcelExpert]

Already uploaded. Please watch the below video: kzbin.info/www/bejne/onPYmq1qi6x3sKM

[@nidak618]

Question: I want to create a checkbox (like the HIGHLIGHT HOLIDAY one) but for different kids onf meetings with different colours... eg. Board level meetings in red, team meetings in yellow, etc. AND like this video: "Dynamic Calendar with Single formula connected with Task List || No VBA Used", I want to show a list of all the meetings that I highlight (instead of tasks list). How do I do that?

[@jillbentley3448]

Great video, but when I uncheck my holiday button all the cells in my calendar change to the colour I chose for the holidays

[@ramzifly9640]

There is a problem with the file, the file does not open

[@yeemei5385]

How come the date 01.01.2024 is tuesday?

[@yadagirigaddam5386]

Hello Jatin two times I was paid money but you not send links

[@deepeepanda]

The template download link not working !!!

[@PKAnExcelExpert]

Please try now.

[@josip.harasic]

Working... Right click > Save link as...

[@redhaakhund1271]

Amazing brother 👍👍👍👍👍am trying to download, and nothing is happening! Plz advise

[@PKAnExcelExpert]

Please try now.

[@redhaakhund1271]

done. Thanks

[@pedrovazquez59]

not work properly if you change year

[@ashutoshpatel19]

Sir please make video multiple worksheet in to one sheet consolidate VBA in excel

[@rafiacademichome6856]

Sheet unreadable,Please sir, how to Solved . Others sheet not work Sheet unreadable

[@ashutoshpatel19]

Sir please make Excel worksheet compiler in VBA

[@PKAnExcelExpert]

Please watch the below video: kzbin.info/www/bejne/onPYmq1qi6x3sKM

[@ashutoshpatel19]

This is workbook complier We have require worksheet complier for example one Excel workbook in many worksheet data so worksheet complier require

[@rafiacademichome6856]

Sheet unreadable

[@MariCarmen-lj9nw]

Excellent! Thank you very much. I would like also to highlight the current day with a different colour. Can you help me with this?

[@rafiacademichome6856]

Sheet unreadable,Please sir, how to Solved . Others sheet not work Sheet unreadable