Time of Service & Tenure Calculator
Calculate time of service in calendar years, months and days, optionally include the end date, and combine multiple employment periods without double-counting overlaps.
Use the Time of Service & Tenure Calculator
Date Range
One YYYY-MM-DD, YYYY-MM-DD range per line. Overlaps are merged.
Quick Examples
Enter a start date to calculate tenure
Excel formulas
For one continuous elapsed span where A2 is the start and B2 is the end. Additional periods and inclusive-end mode are not represented.
=DATEDIF(A2,B2,"M")
=DATEDIF(A2,B2,"Y")&"y "&DATEDIF(A2,B2,"YM")&"m"
The MD unit is deliberately omitted because Microsoft documents inaccurate-result cases.
Summary
Calculate time of service in calendar years, months and days, optionally include the end date, and combine multiple employment periods without double-counting overlaps.
How it works
- Enter the employee's hire date (start date) in the first field.
- Leave the end date blank to calculate tenure up to today, or enter a custom end date.
- Choose whether the end date counts as a day of service.
- Optionally add other employment periods, one date range per line.
- The calculator instantly shows the total tenure broken down into years, months, and days.
- Copy the result or use the detail panel to see total days and weeks as well.
Use cases
- Determine vesting milestones and cliff dates.
- Calculate severance pay based on years of service.
- Recognize 1-, 5-, 10-, and 25-year work anniversaries.
- Audit employee records for long-service leave eligibility.
- Prepare retirement or separation paperwork with accurate tenure figures.
- Verify probationary-period end dates.