C. R. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Luckily, it is still there, but you have to know the arguments because Excel won't provide any guidance.
This video answers these questions:
is datedif still in excel
is datedif in excel 2016
why does datedif not work in excel
does datedif still work
can't find datedif in excel
does datedif still work
datedif how to use
how excel datedif works
how to add datedif function in excel
how to get datedif in excel
how to enable datedif function in excel
what replaced datedif in excel
how to use datedif
This video answers these questions:
is datedif still in excel
is datedif in excel 2016
why does datedif not work in excel
does datedif still work
can't find datedif in excel
does datedif still work
datedif how to use
how excel datedif works
how to add datedif function in excel
how to get datedif in excel
how to enable datedif function in excel
what replaced datedif in excel
how to use datedif
Transcript of the video:
Today's Excel short: Ohh no is DATEDIF gone? Can't be gone.
There's too many spreadsheets that are using it. It pretends like it's not there.
It's not in the list. See.
But as long as you know that it's there and you know how it works.
Put in a start date, put in an end date, and then put in one of these codes, like, “y”.
So that's 57 years. 691 months.
21,047 days. YM means months in excess of full years, so 57 years, seven months. YD is days in excess of full years of 57 years, 228 days. And then MD is days in excess of full months.
So between those two dates, 57 years, seven months, 16 days.
Phew, it is still there. If you like these videos, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments in the comments below.
There's too many spreadsheets that are using it. It pretends like it's not there.
It's not in the list. See.
But as long as you know that it's there and you know how it works.
Put in a start date, put in an end date, and then put in one of these codes, like, “y”.
So that's 57 years. 691 months.
21,047 days. YM means months in excess of full years, so 57 years, seven months. YD is days in excess of full years of 57 years, 228 days. And then MD is days in excess of full months.
So between those two dates, 57 years, seven months, 16 days.
Phew, it is still there. If you like these videos, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments in the comments below.
