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.
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.
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
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
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 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...
🚀 Take our Data Analyst Program here: www.careerprinciples.com/career-track/the-data-analyst-program
Very helpful as always!!
there's more to dates than I thought...thanks
Great video ❤❤❤❤
thank you!
Usual dose of greatness ! thanks
Glad you enjoy it!
@@KenjiExplains IDK if you have one but in case you dont can we have a similar vid for time , please?
Thank you Kenji
Thank you for watching :)
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.
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.
Thanks
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
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
Here we go
Thank you for watching :)
Datedif function isn't available.
my excel doesn't have DATEDIF FN
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 )
Thank you! Why do you think the method shown here isn't accurate? Would be nice to understand your thoughts on the method proposed
@@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...
😮
Datedif doesn’t work in excel for some reason
Hey I think you need to type it manually so type the whole function =DATEDIF(
Excel seems to have it hidden for some reason