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...
@jeevd0007
4 ай бұрын
@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. 😁😉
@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
@mmitchellhouston
4 ай бұрын
THANK YOU. You really saved the day and made me look like a hero.
@PKAnExcelExpert
4 ай бұрын
Thanks for your valuable feedback
@DanKnight
Жыл бұрын
Excellent use of Conditional formatting and functions. Also, well explained.
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
@NicoleUnfiltereddd
10 ай бұрын
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!
@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
@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?
@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
@fromyk1999
8 ай бұрын
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
5 ай бұрын
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
2 ай бұрын
@@walebello9125 I have exactly the same issue. Have you been able to find a solution?
@DBALextras
2 ай бұрын
Thank you for this very good tutorial!
@PKAnExcelExpert
2 ай бұрын
Most welcome
@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?
@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
@mbusombatha750
Ай бұрын
I will definitely try it, thanks PK
@PKAnExcelExpert
Ай бұрын
Most welcome
@donbogdala5428
11 ай бұрын
Thanks for the Lesson!
@PKAnExcelExpert
11 ай бұрын
Most welcome🙏
@omotosojamiuoluwatimileyin7554
6 ай бұрын
This is so lovely and life saving
@PKAnExcelExpert
6 ай бұрын
Thanks 🙏
@giacheng3284
Жыл бұрын
Hi PK, this is an awesome video/lesson! Thank you for posting; it has helped tremendously with a project of mine.
@PKAnExcelExpert
Жыл бұрын
Most welcome🙏
@candicecwl8186
6 ай бұрын
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.
@fballivian
2 жыл бұрын
Excelente aplicacion, saludos desde La Paz Bolivia!!
@PKAnExcelExpert
2 жыл бұрын
Gracias por sus valiosos comentarios
@ravirajagopalan4983
2 ай бұрын
Sooooperb
@PKAnExcelExpert
2 ай бұрын
Thank you so much
@gabih.2169
10 күн бұрын
awesome! thank you:)
@PKAnExcelExpert
10 күн бұрын
You're welcome!
@natasmart1191
Жыл бұрын
Thank you so much! it was really helpful!
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
@fernandocaceres9930
2 жыл бұрын
Many thanks PK!!
@PKAnExcelExpert
2 жыл бұрын
Most Welcome
@mayowasholola493
2 жыл бұрын
I love this video Well done.
@PKAnExcelExpert
2 жыл бұрын
Thanks
@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.
@Mike_Jones281
Жыл бұрын
Well done! I learned a lot!
@PKAnExcelExpert
Жыл бұрын
Thanks for your valuable feedback🙏
@KS-bn6dd
10 ай бұрын
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 🎉
@nadahkhi
11 ай бұрын
Excellent job
@PKAnExcelExpert
11 ай бұрын
Thank you very much!
@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.
@MonpassornChuntharath
Жыл бұрын
TQVM.... It's awesome, and really useful for me.
@PKAnExcelExpert
Жыл бұрын
You're most welcome
@sureshkumarreddyp1621
Жыл бұрын
Thank you so much, it is very usefull me
@PKAnExcelExpert
Жыл бұрын
Glad it was helpful!
@AnaCaroFF
4 ай бұрын
Great, this was easy to follow!
@PKAnExcelExpert
4 ай бұрын
Thanks
@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
@memeumrashid
2 ай бұрын
This is AMAZING!!! Thanks a lot... is there away we can select the tasks by day?
@user-mo3tj5zu3z
Ай бұрын
Brilliant! Thank you
@PKAnExcelExpert
Ай бұрын
Most welcome
@roncustodio1778
7 ай бұрын
NIce one! I've been following your since before.
@crispinaleck5563
2 жыл бұрын
Excellent my professor
@PKAnExcelExpert
2 жыл бұрын
Many many thanks
@ahmedmokhtar190
2 жыл бұрын
Master piece wow thanks
@PKAnExcelExpert
2 жыл бұрын
Most welcome 😊
@user-mo3tj5zu3z
Ай бұрын
Legend!
@silentingenuity2583
2 жыл бұрын
Thanks a lot!!! I need this..!
@PKAnExcelExpert
2 жыл бұрын
You're welcome 😊
@jenneanbruner8879
Ай бұрын
This is a great tutorial but the amount of ads was extremely disruptive
@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
@Curic-Ivan
6 ай бұрын
Thank you!
@PKAnExcelExpert
6 ай бұрын
You're welcome!
@astadoodles4971
8 ай бұрын
Thank you so much 🙂
@PKAnExcelExpert
8 ай бұрын
Most welcome🙏
@huseyinbakir2017
2 жыл бұрын
Thanks teacher.
@PKAnExcelExpert
2 жыл бұрын
You are welcome
@excelwardak100
2 жыл бұрын
Wow very easy way
@PKAnExcelExpert
2 жыл бұрын
Thanks a lot 😊
@jacksonsitompul8918
4 ай бұрын
Nice,.thanks
@PKAnExcelExpert
4 ай бұрын
Most welcome
@Gillian-bt9eo
4 ай бұрын
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.
@pandharinathjoshi6565
2 жыл бұрын
Great sir…💐💐💐
@PKAnExcelExpert
2 жыл бұрын
Thanks
@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
@saraessa9574
Ай бұрын
19:46 correct one is =FILTER('Task list'!A:D, ('Task list'!A:A >= Calendar!J2) * ('Task list'!A:A
@Nuy-wx5ze
8 ай бұрын
thank you so much for the tutorial, can you please make for the microsoft 2019
@mrCetus
2 жыл бұрын
Gracias amigo usted un fregonazo mis respetos gracias por compartir y enseñarnos excelentes vídeos saludos 欄欄
@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
@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?
@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
@sudhanshusawant8105
4 ай бұрын
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?
@sofiamecon7985
Жыл бұрын
If you use a date range, how would the formula be so that the range is seen in the calendar?
@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
9 ай бұрын
Thank you!@@jialei5512
@afia.homaira
2 жыл бұрын
helpful indeed❣️❣️
@PKAnExcelExpert
2 жыл бұрын
Thanks
@jetshows
7 ай бұрын
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?
@kchiranjeevi5662
2 жыл бұрын
Super Sir
@PKAnExcelExpert
2 жыл бұрын
Thanks
@ArunKumar-wm6xb
11 ай бұрын
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
@leopoldopangilinan7223
3 ай бұрын
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
@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
2 ай бұрын
@@jamestierney601 I'm having the same issue. Any solution?
@huangselena2669
2 ай бұрын
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.
@maraki199077
6 ай бұрын
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?
@soumiamoujane3695
6 ай бұрын
I'm having trouble with the filter function formula. I follow the steps shown in the video, but it won't work
@St.RicaCandice1
4 ай бұрын
No Task Available, is not working for me 😢
@NaveenKumar-hg1xt
2 ай бұрын
Hi, I am unable to use filter function in excel 2007 is there any other alternative formula for filter option
@yassinaly3161
8 ай бұрын
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
Жыл бұрын
Me only permision gablesyou terimakasih solusion🎉🎉
@donovanholloway4804
2 ай бұрын
Hi. How could I combine the same tasks that span over multiple days? I don’t want the same task showing multiple times. Thanks!
@securitychannel1671
11 ай бұрын
Good job. Which office version do you use for this tutorial?
@PKAnExcelExpert
11 ай бұрын
Office 365
@abdulahad-mb6hf
Ай бұрын
Thank you sir❤❤❤ But i can not connect month with spin button that formula not work for me
@CarlosFernandes-hl6vk
Ай бұрын
same here
@manjulavaradharaj3218
18 күн бұрын
Hi...instead of filter can vlookup used....pls explain and support
@krishnamiracle7260
5 ай бұрын
In Excel 2016 filter button is not active what should I do
@jafarhussain6606
2 жыл бұрын
awesome. Thank you so much
@PKAnExcelExpert
2 жыл бұрын
You're very welcome!
@gabrielpierre3207
7 ай бұрын
I followed all the steps, but for some reason the month field formula does not work. The month stays as January no matter what number is in the cell above. I even downloaded the template, and the same thing happen as soon as pressed the spin button.
@abelayele8643
3 ай бұрын
Is it possible to create a dynamic calendar other than the Gregorian one?
@sachinbagul4476
2 жыл бұрын
Great sir can u please make some daily production planning achivement file in excel
@PKAnExcelExpert
2 жыл бұрын
Will try
@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.
@tunoodawna6525
29 күн бұрын
How to make the form controls in the developer clickable on the web page?
@beatsbyens73
11 ай бұрын
The instructions are great,but the conditional formatting for Row 10 needs to be clarified.
@deepajayaram5226
Жыл бұрын
Hello It was very well done. Can you also show us how to add CW (calendar week) for each row
@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
@inner.voice0798
Жыл бұрын
I don't have a filter option in the formula bar instead which formula I should use. Please advise
@NewYears1978
5 ай бұрын
Should mention at the start that uses formulas not available in versions before 365.
@ericomenta
9 ай бұрын
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!
@niloferahmed483
10 ай бұрын
Can you please help me out how to extract data of only one specific day of the month? Waiting for your reply.
@elizarvalenzuela874
Жыл бұрын
Itry but filter function in my excel not show only filterxml only
@Jojosmith342
2 жыл бұрын
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
@michaelschaffer1707
20 сағат бұрын
Has anyone figured out how to create either macro or a button command, that will take the calendar back to today's date if we've used the spin buttons to put us forward in time?
@walebello9125
5 ай бұрын
Thank you for this wonderful tutorial. However, This formula =TEXT(C1&"/1/2020","MMMM") does not change the months. I am using Microsoft 365. Kindly help
@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
Пікірлер: 236