HR
Work Anniversary Calculator
Find an employee's completed years of service and their next work anniversary date.
How the calculation works
Compares the start date's month and day against today to count full completed years of service, the same way age is calculated. It then finds the next anniversary date, today's date if today is the anniversary, otherwise the next upcoming occurrence, and how many days away that is.
Formula
Completed Years = Full years elapsed from Start Date to today. Next Anniversary = the next occurrence of the Start Date's month and day, today or later.
Examples
Started Aug 10, 2016 (as of Aug 10, 2026)
10 years of service; next anniversary Aug 10, 2027 (365 days away)
Started Nov 1, 2023 (as of Aug 10, 2026)
2 years of service; next anniversary Nov 1, 2026 (83 days away)