Calculate length of employment in years, months and days from a start date to today or an end date, plus average team tenure or a start or end date.
Related Calculators
- Date Calculator
- Anniversary Calculator
- Absolute Age Calculator
- Internship Hours Calculator
- All Everyday Life and Education Calculators
- Adjusted Hire Date and Credited Service Calculator
Length Of Employment Formula
The calculator uses a different formula for each tab.
Individual length measures the time between a hire date and an end date:
Average tenure divides combined service across the group:
Find a date shifts a known date forward or backward by the given duration:
- StartDate: the hire or rehire date
- EndDate: the separation date or today's date
- Length: total service expressed in years, months, and days, or as total days
- CombinedLengthOfService: the sum of every included employee's tenure, in years, months, or days
- NumberOfEmployees: the headcount used as the denominator
- Years, Months, Days: the duration components used to shift a known date
The Individual length tab returns calendar years, months, and days plus a total day count. The Average tenure tab converts your combined service to days, divides by headcount, and converts back. The Find a date tab adds the duration to a start date or subtracts it from an end date, with a one-day adjustment when the final day of employment is counted.
Reference Tables
Use these to sanity-check your results and set expectations.
| Tenure bracket | Approx. days | Common label |
|---|---|---|
| Less than 90 days | 0 to 89 | Probationary |
| 90 days to 1 year | 90 to 365 | New hire |
| 1 to 3 years | 366 to 1,095 | Established |
| 3 to 5 years | 1,096 to 1,826 | Mid-tenure |
| 5 to 10 years | 1,827 to 3,652 | Long-tenure |
| 10+ years | 3,653+ | Veteran |
| Unit | Days used by this calculator |
|---|---|
| 1 week | 7 |
| 1 month (avg.) | 30.436875 |
| 1 year (avg.) | 365.2425 |
Examples and FAQ
Example 1 – Individual length. An employee was hired on March 15, 2019, and left on August 31, 2024. With the final day not counted, the length is 5 years, 5 months, 16 days, or 1,996 total days.
Example 2 – Average tenure. A team of 12 employees has 87 combined years of service. Average tenure is 87 / 12 = 7.25 years per employee, or about 7 years and 3 months.
Should I count the final day of employment? Count it if the employee was paid for that day or remained on the roster through end of business. Leave it uncounted if the date you entered is the first day they were no longer employed.
Why is my "approximate years" different from "years, months, days"? The years/months/days output uses real calendar months. The approximate values divide total days by 365.2425 and 30.436875, which are average lengths. Both are correct, just measured differently.
How should I handle a rehire? If your policy treats rehires as continuous service, enter the original hire date. If it resets tenure, enter the rehire date.
Which employees go in the average? Enter the number of employees whose service you added up. The denominator must match the group whose service hours you summed.
