How to Use DATEDIF in Excel: Calculate Age and Date Differences
- Tahir Abbas
- November 18, 2026
DATEDIF is a handy Excel function for finding the gap between two dates in complete years, months or days. It is the standard way to calculate a person’s age, an employee’s length of service, the age of an invoice or the time left on a contract. The function is a little unusual, because it does

