How to use datedif function in Excel?
How to find date difference between two dates in Excel?
How to find date difference by month, year or days in Excel?
Excel has a built-in function and does the heavy lifting to date difference between two dates.
Excel uses the “datedif” function to easily compute the date difference by days, months or years.
Notice the Datedif function has a single “f” at the end it’s not DateDiff. If you accidentally type double “f” at the end of the function excel will return an error and will just display “#NAME?” which basically means that the function is not recognized by Excel.
Here’s the function:
=DATEDIF(A1,C1,"d") ==== > this function find the date difference by days for the values of A1 and C1
=DATEDIF(A3,C3,"m") ==== > this function find the date difference by months for the values of A3 and C3
=DATEDIF(A5,C5,"y") ==== > this function find the date difference by years for the values of A5 and C5
Excel screen shot showing datedif function:
Excel Keyboard shortcuts guide