Make an Awesome Dynamic Calendar in Excel

[@KenjiExplains]

📈 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

[@TheOceanLounge27]

I managed to follow along and create the calendar, thank you - really helpful and clear :)

[@giuseppeantonioferro3500]

Complimenti, i tuoi tutorial sono tutti molto interessanti. Ti seguo da Torino, Italia, metto i sottotitoli perché non riesco a seguire tutto in inglese ma riesco comunque ad apprendere quello che fai. Ancora complimenti, anche per il tuo modo di spiegare, calmo, preciso e sempre con un sorriso. Grazie per quello che fai

[@Excelambda]

Great video!! Cool methods!!✌🏼 One missing, so, for fun , a single cell lambda method , can be called anywhere, and does everything, (includes format): Define function called "YMD" ,Year Month Day , a composed lambda of these parameters: YMD([y],[m],[d])([w]) , where: [y]: year : numeric, (2024 or 24) , if omitted =current year [m]: month : numeric or string ( 6, 06 , "jun", "june" ) , if omitted = current month [d]: day : numeric , if omitted =current day [w] : week num argument, if omitted wk.nr. does not show, if w=1, wk.nr. will show. Note : the reference dates for the wk.nr. calc is the column that includes first day of month. =LAMBDA([y], [m], [d], LAMBDA([w], LET( n, NOW(), f, --(1 & "-" & IF(m = "", MONTH(n), m) & "-" & IF(y, y, YEAR(n))), h, IF(d, d, DAY(n)) + f - 1, x, f - WEEKDAY(f, 3) - 14, a, SEQUENCE(8, 7, x), t, " " & TEXT(a, "d"), i, IFS( a > EOMONTH(f, 0), t, a = h, TEXT(a, "| dd |"), a >= f, TEXT(a, "- dd -"), a >= x + 14, t, a >= x + 7, TEXT(a, "|ddd|"), a = x + 1, YEAR(f), a = x, TEXT(f, "mmm"), 1, "" ), IF(w, HSTACK(VSTACK({""; "Wk"}, WEEKNUM(f + 7 * SEQUENCE(6, , 0), 2) & ""), i), i) ) ) ) Examples: - calling "today" =YMD()() - calling "today" + wk.nr. =YMD()(1) - same date as current date but next year (2025) =YMD(25)() =YMD(,"aug")(1) or =YMD(,"august")(1) or =YMD(,8)(1) - xmas current year =YMD(,12,25)(1) - 4th July next year (2025) =YMD(2025,7,4)()

[@evy_parody9320]

Mr Kenji, first thank you for yet another one. Secondly I would love it if you could be telling us after a lesson,where that skill you've taught us we can apply it. It'd be so helpful. Thank you

[@KenjiExplains]

Thanks for the suggestion! I'll keep it in mind :)

[@kijanicapitalmedia]

Seriously you want to be spoon fed everything? Even the application?

[@simaculet1133]

Thank you! Clear and easy instructions to follow.

[@simaculet1133]

I got a question tho', how should I make a tracker list and display it within the cell of this calendar automatically?

[@simaculet1133]

Hope you can help me on this. 😢 thank you 😅

[@somasundaramv4865]

Nice One Kenji, Loved it, the Mini Calendar in Excel

[@KenjiExplains]

Glad you liked it!

[@estelledesplats4805]

Thank you! Very helpful video

[@Mtuji1]

Hi, Writing appointments in the calenda? Do you have a meetings attendance list calendar?

[@Sheards]

Can I use this dynamic calendar as date filter for my table?

[@albedoguardian875]

Top Notch Tips. Kenji Rocks

[@AllenBennett-vp6gd]

How would we add a different icon/picture (in row 2 in your formula example) depending on the month selected? Like maybe a heart for February, or falling leaves for September, etc.

[@balaandrews]

Can't sequence function thn how to implement alternative function. Plz

[@GauriGupta-uv7on]

Thank you so much!!!! ✨✨

[@Aitimoney]

Question, I use Quicken for my accounts. I'm thinking about building from your Excel budget video. In this calendar video, I want to use to show my bills due for a month. Just use the start of your video that was built in, and list bills?

[@TechnoEveryday]

Awesome 🎉🎉🎉

[@clementverdier2655]

Thanks Kenji for the vid! What is the best way to be able to write down tasks for the day; would that be by adding memos? Maybe is there a better solution?

[@camlex6310]

Great video!! Thanks

[@willzinner8813]

didn't know the mini calendar thank you

[@KenjiExplains]

Thanks for watching :)

[@patel-h2u]

hello kenji, i want an advice for you , should i mention that i am preparing for cfa level-1 in my cover letter for goldman sach new summer analyst(IB)?

[@chrisvi3019]

Can you just guide for shift calculation ? My team is working 7 days on and 7 days off, Is there anyway for me to enter the start date of the shift and It will highlight for the total 7 days, and automate calculate the next shift ( after 7 days off), our start date of the shift always starts on Wed. TIA

[@jessmaryse5648]

Thank you so much!!!

[@calcoleman4372]

The Week # seems to be ending at 31 and starting over again. Can you please fix? Thank you!

[@tavonclayborn9419]

Change the Week Number cell formatting to number. It’s currently in the custom “day” format causing it to stop at 31

[@UtkarshKumar-mp2ls]

Good night Kenji

[@KenjiExplains]

Thanks for watching!

[@Dexter101x]

Cool

[@NoName-jw3uy]

There is a typo in your thumbnail image. Dyanmic

[@KenjiExplains]

Thanks for letting me know!

[@EnweremChukwuka]

🤢