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

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

4 күн бұрын

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

@kijanicapitalmedia

3 күн бұрын

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

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

@KenjiExplains

4 күн бұрын

Glad you liked it!

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)()

Great video!! Thanks

Top Notch Tips. Kenji Rocks

Thank you so much!!!

Awesome 🎉🎉🎉

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?

didn't know the mini calendar thank you

@KenjiExplains

4 күн бұрын

Thanks for watching :)

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)?

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

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?

Good night Kenji

@KenjiExplains

4 күн бұрын

Thanks for watching!

Cool

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

@tavonclayborn9419

3 күн бұрын

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

There is a typo in your thumbnail image. Dyanmic

@KenjiExplains

4 күн бұрын

Thanks for letting me know!

Hi Kenji, thanks a lot, very useful content! Based on your idea, I created a LAMBDA to do it w/o effort ;-) I used the same week structure: Monday as first day. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The LAMBDA creates monthly calendar with week numbers. ARGS: [cyear] - as optional, w/o argument we get: YEAR(TODAY()), [cmonth] - as optional, w/o argument we get: MONTH(TODAY()), [isdate] - as optional boolean, 0 is FALSE, w/o argument is FALSE, >=1 is TRUE in case of FALSE - we get dates and need to apply custom formatting in case of TRUE - we get pre-formatted numbers --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- myCALENDAR=LAMBDA( [cyear], [cmonth], [isdate], LET( header, HSTACK("Wk", "Mo", "Tu", "We", "Th", "Fr", "Sa", "Su"), myday, DATE(YEAR(TODAY()), MONTH(TODAY()), 1), firstday, IF(OR(ISOMITTED(cyear), ISOMITTED(cmonth)), myday, DATE(cyear, cmonth, 1)), weeknr, WEEKNUM(EOMONTH(firstday, 0), 2) - WEEKNUM(firstday, 2) + 1, firstdaynr, WEEKDAY(firstday, 2), datearray, SEQUENCE(weeknr, 7, IF(firstdaynr = 1, firstday, firstday - firstdaynr + 1), 1), weekarray, WEEKNUM(CHOOSECOLS(datearray, 1), 2), calendararray, HSTACK(weekarray, datearray), myboolean, IFS(isdate = 1, TRUE, isdate = 0, FALSE, ISOMITTED(isdate), FALSE, TRUE, TRUE), calendararrayformatted, HSTACK( TAKE(calendararray, , 1), VALUE(TEXT(DROP(calendararray, , 1), "d"))), body, IF(myboolean, calendararray, calendararrayformatted), calendar, IFERROR(VSTACK(header, body), ""), calendar)) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------