Master Date Functions in Excel (HUGE time saver)

[@KenjiExplains]

🚀 Take our Data Analyst Program here: www.careerprinciples.com/career-track/the-data-analyst-program

[@camlex6310]

Very helpful as always!!

[@willzinner8813]

there's more to dates than I thought...thanks

[@mahmoudmohsen8105]

Usual dose of greatness ! thanks

[@KenjiExplains]

Glad you enjoy it!

[@mahmoudmohsen8105]

@@KenjiExplains IDK if you have one but in case you dont can we have a similar vid for time , please?

[@mohammadalbizri2013]

Thank you Kenji

[@KenjiExplains]

Thank you for watching :)

[@HealthinMotion-uu4li]

Great video ❤❤❤❤

[@KenjiExplains]

thank you!

[@ericssontest2332]

Thanks

[@michaelt312]

Great video. I love your straightforward presentation. May I ask what software or plug-in you use to mark and highlight? Not sure if I asked before. Thanks in advance.

[@utkarshsinha3277]

Here we go

[@KenjiExplains]

Thank you for watching :)

[@antwanboyd1]

I'm trying to do a schedule that has date ranges that starts one day before a date and end one day with 2 days in between. Any help would be appreciated.

[@dreamtofly3304]

Do i need to do cfa to become a hedge fund or private equity portfolio manager if i already have bba and mba in finance from average university. Pls answer

[@darickgetachew8568]

Why is same like you the date, when I try to write the date like this jan-1 the excel change to 1-jan, then I try to write the date like this jan-1, the I put the function =edate (the date, 1) the resalt is 45323 how please can you help

[@profemanuperez]

Very good video but... the only way to get an accurate Age any time is by this way = IF (BirthdayCurrentYear > TODAY( ) ; YEAR(TODAY( ))-YEAR(Birthday); YEAR(TODAY( )) - YEAR(Birthday) - 1 )

[@KenjiExplains]

Thank you! Why do you think the method shown here isn't accurate? Would be nice to understand your thoughts on the method proposed

[@profemanuperez]

@@KenjiExplains it's not completely accurate.. it depends on the periods of years.. that's why it's not an "official" function in Excel.. It's all about the number of days in February and also the number of real days each year, I think.. anyway, the method I wrote down is like the old fashion method but the most accurate one...

[@anjelas2708]

Datedif function isn't available.

[@prakashabhijeet]

my excel doesn't have DATEDIF FN

[@ericssontest2332]

😮

[@mayurg95]

Datedif doesn’t work in excel for some reason

[@KenjiExplains]

Hey I think you need to type it manually so type the whole function =DATEDIF( Excel seems to have it hidden for some reason