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.
What to do if i want to find difference between two dates, but in hours? Also if dates are entered in TEXT format in multiple columns, what should I do to change them quickly?
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
there's more to dates than I thought...thanks
Very helpful as always!!
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 ❤❤❤❤
thank you!
Thanks
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.
Here we go
Thank you for watching :)
I want to learn on power BI
What to do if i want to find difference between two dates, but in hours? Also if dates are entered in TEXT format in multiple columns, what should I do to change them quickly?
Is it necessary to customize date formats if there are already so many formats available under “Date” category? Just a thought
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
What about quarters for a company whose fiscal year differs from the calendar year? If the FY begins in September…?
I don't see the function "Datedif" in my excel even though its updated. Is there any other way to get it?
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
😮
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