Tip Printed from ExcelTip.com

---

Calculating Differences Between Dates


To calculate the difference between dates:

Use the DATEDIF function. The results of the calculation are displayed as days, full months, and full years.

Note: The DATEDIF function is not included in the Insert Function dialog box.