How to used The Excel DATEDIF Function?

There is no datedif function in Excel. You can use this formula to calculate the number of months: =(YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MONTH(EDate) LDate is the cell where the later date can be found. ex: A1 EDate is the cell where the earlier date can be found. ex: A2 Try it! Good luck!