Dynamic Calendar with Single formula connected with Task List || No VBA Used

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

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

50% 1

#TaskList #ExcelCalendar
Hello Friends,
In this video, you will learn how to create a Dynamic Calendar in Microsoft Excel. We have used a Single formula to create this Dynamic Calendar. We have displayed two form control Spin buttons to change the Month and Year of the calendar. On the Right-hand side, we have displayed the Filtered Task List. We have used the Filter function to show the Filter task list. We have used multiple conditional formatting to hight the days in Calendar and Red, Amber, and green text in Task List according to the status of the task.
Download the practice file from the below link:
www.pk-anexcelexpert.com/dyna...
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best infographics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

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

11 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@NicoleUnfiltereddd 9 месяцев назад

Really excited to use this calendar for my team at work. I feel like they will all be wowed with the level of efficiency this can bring us. I’ve learning from a mastermind!

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

Parabéns grande mestre! Esta materia chegou em boa hora! Obrigado! (Congratulations great master! This article came at just the right time! Thank you!)

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

Thanks for your valuable feedback.

@jeevd0007 3 месяца назад

@PK, you're making the learning a no-code or low-code like for Excel users. Your knowledge, pace of explaining along with the rationale and the end results are pure love of learning which all of us are in love it. Keep the fantastic work you're doing my friend. What a delight to find you and instantly become follower of you. Thanks for all the knowledge sharing you're doing to help the community grow stronger. I'm certainly spreading the word about you in every conversation in my circle. 😁😉

@KS-bn6dd 9 месяцев назад

Thank you so much for sharing your expertise!! It is such a useful tool, and really look forward to using it. Your video was so easy to follow and eventually at the end it did start to make some sort of sense 😅- you’re a legend! Liked & subscribed 🎉

@chalapathi.vchala9156 Год назад

I have 4 years of experience in as mis executive.. I never seen such good explanation and use conditional formating options and you did very useful topic. Thank you soo much...

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

I used this for my client's mini-project for me! THANK YOU AND YOU ARE AMAZING!!!

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

You are so welcome!

@adamgorecki4785 Год назад

did you have trouble getting the formatting formula at the 22:26 mark to work?

@DanKnight Год назад

Excellent use of Conditional formatting and functions. Also, well explained.

@PKAnExcelExpert Год назад

Thanks for your valuable feedback🙏

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

Excelente aplicacion, saludos desde La Paz Bolivia!!

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

Gracias por sus valiosos comentarios

@phoebedavis5526 Год назад

Great looking calendar, I really like the end result. I ended up using someka dynamic calendar on Excel though, it's very detailed and easy to use on a daily basis. Thank you for the video.

@PKAnExcelExpert Год назад

Thanks

@BenDieselBasicAutomotive Год назад

Wow!... Only the mentally gifted persons can design this kind of programming. Thank you very much Sir, for the learning...Hoping that I can follow those very complex (yet very detailed) instructions. Just wonderin' if an ordinary mortal like me could replicate the formulas...... Thank you very much....

@PKAnExcelExpert Год назад

Thanks for your valuable feedback

@misterwill3625 Год назад

Excellent video! This is better than Microsoft Outlook tasks. I saved this video to try it for a new project. Thank you.

@PKAnExcelExpert Год назад

Most welcome

@giacheng3284 11 месяцев назад

Hi PK, this is an awesome video/lesson! Thank you for posting; it has helped tremendously with a project of mine.

@PKAnExcelExpert 11 месяцев назад

Most welcome🙏

@mmitchellhouston 2 месяца назад

THANK YOU. You really saved the day and made me look like a hero.

@PKAnExcelExpert 2 месяца назад

Thanks for your valuable feedback

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

Very well done and awesome calendar. Another way to prevent the bleeding of the blue taks markings to the next month is to make sure it is the first rule.... rules are done in order top to bottom, so if you add the rule and using the arrows you move it up you will get the same results. Love it!

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

Hi Hagai! I created a yearly calendar and I cannot figure out how to have it not highlight the days from the month previous and following when highlighting my events. Any ideas?

@fromyk1999 6 месяцев назад

Thank you so much. This took a bit of time to get done because some of the formulas you used did not work in Office 365, but I was able to correct them and now everything on mine works like yours done. Fantastic Job!!

@walebello9125 3 месяца назад

This formula =TEXT(C1&"/1/2020","MMMM") does not change the months. I am using Microsoft 365. Were you able to correct it.

@Adam_s_1975 18 дней назад

@@walebello9125 I have exactly the same issue. Have you been able to find a solution?

@o.turkmen 2 года назад

Yine her zaman ki gibi harikasın, Türkiye ve Cezayir’den selamlar 🖖

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

Değerli geri bildiriminiz için teşekkürler

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

Creating a Dynamic calendar is a good job. I mainly focus to create calendar first by one by one step. After this Filter formula filter the our task. A good revision of Conditional Formatting is also done. I found that the same is not working when we go US Indian Calendar to US date. I also solve this error by using ( If and Text ) function so formula work on both date US and Indian. However in mobile form control buttons are not working. I also solve without using Filter function so that same may be useful for others also. Very very thank to you. Now, I am trying to switch the use of this in google sheets also.

@natasmart1191 Год назад

Thank you so much! it was really helpful!

@PKAnExcelExpert Год назад

Thanks for your valuable feedback🙏

@candicecwl8186 4 месяца назад

Great tutorial and you explained it well. I followed along, the only thing I did differently was setup a table for my Task list,. I will probably attempt to take this a step further and instead of doing the rule on dates with active tasks, I would rather highlight the current date.

@DBALextras 17 дней назад

Thank you for this very good tutorial!

@PKAnExcelExpert 17 дней назад

Most welcome

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

NIce one! I've been following your since before.

@Mike_Jones281 Год назад

Well done! I learned a lot!

@PKAnExcelExpert Год назад

Thanks for your valuable feedback🙏

@donbogdala5428 10 месяцев назад

Thanks for the Lesson!

@PKAnExcelExpert 10 месяцев назад

Most welcome🙏

@mayowasholola493 Год назад

I love this video Well done.

@PKAnExcelExpert Год назад

Thanks

@MonpassornChuntharath Год назад

TQVM.... It's awesome, and really useful for me.

@PKAnExcelExpert Год назад

You're most welcome

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

Gracias amigo usted un fregonazo mis respetos gracias por compartir y enseñarnos excelentes vídeos saludos 欄欄

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

Many thanks PK!!

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

Most Welcome

@omotosojamiuoluwatimileyin7554 4 месяца назад

This is so lovely and life saving

@PKAnExcelExpert 4 месяца назад

Thanks 🙏

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

Excellent my professor

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

Many many thanks

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

Thanks a lot!!! I need this..!

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

You're welcome 😊

@comoaprenderdetodounpoco6262 Год назад

Although this is a year old it has not lost any value at all. You're a FANTASTIC teacher, not only you taught me, but inspire me to create - THANK YOU! This channel is my "learning space" and I ONLY subscribe to channels that are exceptional - you earned a new subscriber. Semper Fi

@PKAnExcelExpert Год назад

Thanks for your valuable feedback and subscribing

@AnaCaroFF 3 месяца назад

Great, this was easy to follow!

@PKAnExcelExpert 3 месяца назад

Thanks

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

Master piece wow thanks

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

Most welcome 😊

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

Gracias amigo usted un fregonazo mis respetos gracias por compartir y enseñarnos excelentes vídeos saludos 🇲🇽🇲🇽🇲🇽🤝🤝

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

Gracias por sus valiosos comentarios

@sureshkumarreddyp1621 Год назад

Thank you so much, it is very usefull me

@PKAnExcelExpert Год назад

Glad it was helpful!

@user-mo3tj5zu3z 2 дня назад

Brilliant! Thank you

@PKAnExcelExpert 2 дня назад

Most welcome

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

Thanks teacher.

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

You are welcome

@afia.homaira 2 года назад

helpful indeed❣️❣️

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

Thanks

@nadahkhi 9 месяцев назад

Excellent job

@PKAnExcelExpert 9 месяцев назад

Thank you very much!

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

Great sir…💐💐💐

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

Thanks

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

awesome. Thank you so much

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

You're very welcome!

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

Thank you!

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

You're welcome!

@astadoodles4971 7 месяцев назад

Thank you so much 🙂

@PKAnExcelExpert 7 месяцев назад

Most welcome🙏

@user-mo3tj5zu3z 2 дня назад

Legend!

@memeumrashid Месяц назад

This is AMAZING!!! Thanks a lot... is there away we can select the tasks by day?

@deepajayaram5226 Год назад

Hello It was very well done. Can you also show us how to add CW (calendar week) for each row

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

Super Sir

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

Thanks

@jacksonsitompul8918 3 месяца назад

Nice,.thanks

@PKAnExcelExpert 3 месяца назад

Most welcome

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

Wow very easy way

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

Thanks a lot 😊

@jagatjitsinghsekhon3719 Год назад

Hi, Thanks for the video, it helped me a lot in my project but one thing I'm still looking into is that how we can repeat the months or years instead of moving back using SPIN BUTTON?

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

wonderful demonstration and instruction. Question: can this dynamic calendar then be linked into iCalendar on a Mac? and can this be similarly accomplished in Numbers on a Mac?

@Gillian-bt9eo 2 месяца назад

Love this tutorial!! Wondering if there's a way to colour code calendar fill colour based on text? So the calendar square could be red, yellow or green depending on the progress of the task.

@Nuy-wx5ze 6 месяцев назад

thank you so much for the tutorial, can you please make for the microsoft 2019

@ravirajagopalan4983 Месяц назад

Sooooperb

@PKAnExcelExpert Месяц назад

Thank you so much

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

Hi. Thank you so much for sharing this idea. But is it possible to show just the Dynamic option of Month and year without showing the entire calendar? Hope you will notice this.

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

Great sir can u please make some daily production planning achivement file in excel

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

Will try

@Jojosmith342 Год назад

Thank you for your lesson. I tried to place a drop down list in this calendar but the name in the list could not be displayed. I hope you could help. Thanks a lot

@anantharamangopakumar2122 Год назад

Hello, thank you for the video. Great help. Spin button for months is not working when tried and in the shared sample sheet as well. Please see.

@securitychannel1671 10 месяцев назад

Good job. Which office version do you use for this tutorial?

@PKAnExcelExpert 10 месяцев назад

Office 365

@hariharagupta5638 Год назад

Sir, video was very useful, i have one ask - at the video time 22.38, the month chosen on February, there are 4 entries with 3 completed and 1 in pending, need to highlight in the calendar that completed means one color and pending means other color, kindly help to provide the conditional formatting color( i am using completed for + value and pending for -Value), kindly help to provide the conditional formatting command please also possible if there is a chance, on the highlighted dates in the calendar if we keep the cursor it should show as completed or pending, it will be more useful if you help with it Sir

@sofiamecon7985 Год назад

If you use a date range, how would the formula be so that the range is seen in the calendar?

@ericomenta 7 месяцев назад

What if I want to base the color formatting for the calendar on the Status as well? Like I want the Completed ones to be green in the calendar and the WIP ones to show as yellow in the calendar, is that possible? Btw, amazing video!

@afia.homaira 2 года назад

That Great sir!! but, But how many versions of this ms office??

@myarnie1950 Год назад

Can you please supply a work around for those of us who do not have Office 365 version of Excel What can we use instead of the sequence function Thanks

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

💞💞💞👌🏼

@yassinaly3161 7 месяцев назад

Thanks so much, it is very useful But I have just one question to ask please, How can I make task appears based on day by pressing on the day from the created calendar?

@BayuHendra-qe7kg 10 месяцев назад

Me only permision gablesyou terimakasih solusion🎉🎉

@gopalfulara2546 Год назад

Hi. Very nice and informative. While I am changing month it’s not working. Year is changing smoothly. Tried template also and same error coming

@RedzepRedzepi-il8rx Год назад

microsoft office 2019not working Very well done and awesome calendar but Can you please supply a work around for those of us who do not have Office 365 version of Excel What can we use instead of the sequence function and the Filter functionThanks

@hamdaalketbi344 Год назад

Hi, very helpful however when i reached to the point of connecting the task sheet with colander using the formula (FILTER) it is not valid, what formula i can use? Thank you

@ArunKumar-wm6xb 10 месяцев назад

Is it possible to display daily task by clicking date in calender?day to day task only. Is there is any function for it? Kindly help me

@sudhanshusawant8105 2 месяца назад

This is such a great project, man. Kudos to your work. I am hoping you could help me out with this. I am trying to add comments to the dates, however, the comment is reflecting on all the months. How can we tackle this?

@SuperYoonkim Год назад

Hello Sir, thanks for the great video! It was very helpful! Yet I have one question: I want to see the highlights in the calendar for only "completed" tasks and I want to do this adding a third spin button. So when I switch from "completed" to "WIP", the calendar highlights only WIP tasks and not all tasks. Is there any way to do this?

@PKAnExcelExpert Год назад

I will try to create it in the next version

@mataoralivingface Год назад

Rubbish

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

Superv

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

Thanks

@huangselena2669 Месяц назад

Hello PK, if I don't have the filter function in my excel, what are the alternative solutions in order to populate the tasks to the corresponding month in the "calendar sheet", thank you very much.

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

Dear Sir, Great. Only probem as this sequence & filter formula not came in EXCELL version MS office 2019 version. Due to that i am not able to work.

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

Can you please do one video for splitting PDF in customized range like 1-3, 4-10, 11-15 like that using VBA excel

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

I will try to create such video.

@GirijaVallabhan-mz9kf Год назад

The Month in C2 is not changing with Spin Button. But the Year in F2 is working well. Await your valuable advise to resolve this issue

@jialei5512 Год назад

Let format control of the button locate at $B$3 then click the month and edit the formula: =TEXT(DATE(2023,B3,1),"mmmm")

@shobhaabraham 7 месяцев назад

Thank you!@@jialei5512

@ShahNJ0714 11 месяцев назад

I don't have a filter option in the formula bar instead which formula I should use. Please advise

@lukeforsthoefel6026 Год назад

@PK, How can I make it so that instead of the Task List returning "0" when there are no comments, it returns either a blank cell or "N/A"?

@LarsIngeHolen Год назад

Is it possible to add repetitiv tasks? Nice video

@PKAnExcelExpert Год назад

Please watch below videos: Fully Functional To-do List in Excel (Part-1) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0T6PhgAdsqs.html Fully Functional To-do List in Excel (Part-2) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ld-H3GCEMqU.html Fully Functional To-do List in Excel (Part-3) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xf0M929N-P8.html Fully Functional To-do List in Excel (Part-4) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OXChzlXNV8Q.html

@LarsIngeHolen Год назад

Thank you Sir! What can I do to make monday first day of the week in calenday? Have a nice day!!!

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

Great video all in all, thank you! The spin button for the month does not work for me no matter what I do!! It is driving me crazy, I have created the calendar following your steps closely, everything else works except the spin button for the month. Can you shed any light please?

@keylanoslokj1806 9 месяцев назад

Can you connect sales values data to those days?

@abelayele8643 2 месяца назад

Is it possible to create a dynamic calendar other than the Gregorian one?

@pinoyapollo9637 Год назад

how about to have also week number should be dynamic?can you explain please, thank you

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

Hi Sir. I am trying this idea now but I seem to be having a problem with on =Text part for the Month and Year. It doesn't change the calendar. 😭

@karenblakecoaching9601 Год назад

I have had the same issue. Did you manage to resolve it?

@td163 Год назад

@@karenblakecoaching9601 it's rough

@brankabrankica1666 Год назад

=text(“1/“C1,,”MMMM”)

@td163 Год назад

@@brankabrankica1666 what about the task correlating with the calendar. The last step. I typed it how he said and it brings back an error that even when corrected still doesn't work

@praveshrawal8888 Год назад

=text("1/"&C1,"mmmm") it will work

@GreenLeaf210 Год назад

Can i do report connection for other chart also in dashboard

@PKAnExcelExpert Год назад

Yes you can

@leopoldopangilinan7223 2 месяца назад

Hi, can you help me I want to apply the color coding to the calendar same with the task but i dont know the correct condition

@abdulahad-mb6hf 6 дней назад

Thank you sir❤❤❤ But i can not connect month with spin button that formula not work for me

@CarlosFernandes-hl6vk 8 часов назад

same here

@donovanholloway4804 Месяц назад

Hi. How could I combine the same tasks that span over multiple days? I don’t want the same task showing multiple times. Thanks!

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

Dear PK, I am using 365 Home. Presently I am using some problem with PK utility toll 2. I want to re-install it. Please inform how to un-install it properly from add-in. After this I want to install again as it is very very useful add-in

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

Hi Raj, I have explained in the starting of the below video, how to install PK's Utility Tool V2.0 in your Excel. Please start watching from 2:10 Below is the video link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZBPaRMHXSpw.html

@NaveenKumar-hg1xt Месяц назад

Hi, I am unable to use filter function in excel 2007 is there any other alternative formula for filter option

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

hi tried the trick, but the month not changing when clicking the spin button, it only shows January only , even i tried your templet from download link, its also not changing the month . please help with

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

Having the same problem... Any insights? Have you resolved it?

@Adam_s_1975 18 дней назад

@@jamestierney601 I'm having the same issue. Any solution?

@fuzailkashif1519 Год назад

Hi Sir. Can you please make the video on task calendar with date as well. Means if i click on date than i should only pick the task for that date. Of for the i am working in. And also if sequence function is not available than how can we make this calendar.

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

Pls share the calendar excel sheet for task maintenance

@niloferahmed483 8 месяцев назад

Can you please help me out how to extract data of only one specific day of the month? Waiting for your reply.

@anjalipes Год назад

Hi, superb video, but my month value is not becoming dynamic with ur code - =TEXT(C1&"/1/2020","MMMM")- it is not doing anything. Could u please help me here.

@beatsbyens73 9 месяцев назад

The instructions are great,but the conditional formatting for Row 10 needs to be clarified.

@user-em3ye6ob1b 8 месяцев назад

When applying the 'FILTER' function, I do it exactly the same as in the video, and it says, 'No matches were found in the FILTER evaluation.' Does anyone know what's happening?