The Excel DATEDIF function returns the difference between two date values in years, months, or days. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. For reasons unknown, it is only documented in Excel 2000, but you can use it in your formulas in all Excel versions since that time.
The Excel YEARFRAC function returns a decimal value that represents fractional years between two dates. You can use YEARFRAC to do things like calculate age with a birthdate.
In this video you will learn How to Use DATEDIF function and what is YEARFRAC function & use of YEARFRAC function in Excel. Explanation about year difference, month difference, day difference ,date difference .
Ещё видео!