Years of Service Formula

I'm wanting to calculate an employee's years of service from their hire date with no end date. What is the formula? This is the formual that I've entered and I keep getting a syntax error.

(TODAY()-A2)/365

I've also tried

=(TODAY()-A2)/365


A2 is the cell for the employee hire date

MacBook Pro 16″, macOS 14.6

Posted on Jan 31, 2025 11:33 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 31, 2025 12:52 PM

For Numbers:

=DATEDIF(A2, TODAY(), "Y")


For Excel:

=INT(YEARFRAC(A2, TODAY()))
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Years of Service Formula

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.