How do I calculate time of service at a job?

Count the completed years from the hire date, then the completed months, then the remaining days up to the end date. For example, from September 16, 1999 it is 26 years to September 16, 2025, 10 more months to July 16, 2026 and 25 more days to August 10, 2026: 26 years, 10 months and 25 days.

How do I calculate total job tenure in months?

Count the completed calendar months between the start and end dates. September 16, 1999 to August 10, 2026 is 322 completed months (26 × 12 + 10). The calculator shows this as Completed Months, and in Excel =DATEDIF(A2,B2,"M") gives the same figure.

When do I complete 1 year of service from my start date?

One year of service is completed on the same calendar date a year after the start date: a March 15, 2025 start completes one year on March 15, 2026. For a February 29 start, this calculator uses February 28 in non-leap years.

Does the calculator include the start and end dates?

Elapsed calendar tenure starts at the hire date and normally excludes the final endpoint. Enable “Include end date” when payroll or policy counts both the first and last calendar day.

What does "end date" default to?

When you leave the end date blank, the calculator uses today's date at midnight local time. You can override this with any past or future date.

How are months counted when the end day is before the start day?

The calculator uses calendar-month subtraction. If the end day is earlier than the start day in the same month, one month is borrowed and the remaining days are calculated from the previous month's end.

Can I calculate tenure for a past employment period?

Yes — just enter both a start date and a specific end date. The tool works for any date range, past or future.

Can I combine separate employment periods?

Yes. Add one start/end pair per line. The calculator merges overlapping or touching periods before summing service days, preventing double-counting.

How do I calculate the average tenure of my employees?

Work out each employee's tenure up to the same date, add the tenures and divide by the number of employees: 4 employees with 10 combined years average 2.5 years. Paste one hire date per line into the team tenure calculator to get each person's tenure, the average and the median. The median is less distorted by a few very long-serving staff and is the figure the US Bureau of Labor Statistics reports.

What is the average employee tenure in the US?

The median was 4.1 years in January 2026 for wage and salary workers, up from 3.9 years in January 2024 (BLS Employee Tenure release, September 2026). It ranges from 3.0 years for ages 25 to 34 to 9.6 years for ages 55 to 64, and is 5.6 years in the public sector versus 3.9 years in the private sector.

How is part-time service counted?

Many pension and seniority rules prorate part-time work by the share of a full-time schedule (hours worked ÷ full-time hours). Two calendar years at 20 of 40 hours, or 50%, credits about one year of service. Enter the percentage in Part-time % to see credited service days and years; calendar tenure stays unchanged. Check your plan or contract, because some count every calendar day regardless of hours.

Is there a limit on how far back the start date can be?

No practical limit. The calculator handles dates from the 1900s onward.

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.

Time of service at a job is the calendar time from your hire date to your last day (or today), counted in completed years, then months, then leftover days.

Date Range

Start Date (Hire Date)

End Date (leave blank for today)

Include the end date as a service day

Part-time % (100 = full time)

Hours worked ÷ full-time hours. Prorates credited service only.

Additional Employment Periods (optional)

One YYYY-MM-DD, YYYY-MM-DD range per line. Overlaps are merged.

Quick Examples

Enter a start date to calculate tenure

Total 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.

Service milestones

Anniversary dates of the primary start date, counted against the end date.

Milestone	Date	Status

Average tenure calculator for a team

One employee per line: Name, hire date or Name, hire date, end date (YYYY-MM-DD; the name is optional). Tenure is measured to each end date, or to the end date above (today if blank).

—

Average years

—

Median years

—

Employees

Employee	Hire date	Tenure	Years

How long do employees stay? US median tenure, January 2026

Median years wage and salary workers had been with their current employer.

Group	Median tenure
All wage and salary workers	4.1 years
All workers, January 2024	3.9 years
Ages 25 to 34	3.0 years
Ages 55 to 64	9.6 years
Public sector	5.6 years
Private sector	3.9 years
Share with 10 or more years at their employer	31.1%

Source: US Bureau of Labor Statistics, Employee Tenure in 2026 (released September 24, 2026). Tenure here is time with the current employer, not total career length.

Copied!

Quick answer

Time of service at a job is the calendar time from your hire date to your last day (or today), counted in completed years, then months, then leftover days. By the usual elapsed-date method the end date itself is not counted unless your policy includes it.

Example: Hired September 16, 1999, last day August 10, 2026: 26 years, 10 months and 25 days of service, which is 322 completed months or 9,825 days.

Enter your hire date to get years, months, days and total days of service.

Summary

This Time of Service Calculator computes calendar tenure between a hire date and today or a chosen end date. You can explicitly include the end date and add separate employment periods; overlapping periods are merged so the same day is not counted twice. Results include calendar years/months/days, total service days, weeks, decimal years and the next anniversary.

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, and a part-time percentage for credited service.
The calculator instantly shows the total tenure broken down into years, months, and days.
Copy the result, check the service milestone dates, or paste a list of hire dates to get the average and median tenure of a team.

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.

Frequently Asked Questions

Last updated: 2026-10-09 · Reviewed by Nham Vu