# Years of Service Formula Help

Options

Hello Awesome Community,

I have watched videos and searched the threads but I have hit a block and cannot figure out how to calculated the number of years my employees have worked.

I have the Column setup as "Date of Hire" with the date in this format MM/DD/YY and I am trying to figure out the "Years of Service" to today's date so I always have their exact time working for the company.

Please any help would be amazing. Thank you all for your time.

• ✭✭✭✭✭
Options

Hello @Sara.Planchon

Give this formula a shot and let me know if it works for you:

=IF([Date of Hire]@row <> "", YEAR(TODAY()) - YEAR([Date of Hire]@row) - IF(TODAY() < DATE(YEAR(TODAY()), MONTH([Date of Hire]@row), DAY([Date of Hire]@row)), 1, 0), "")

Options

THAT WORKED! You sir are amazing! Thank you!

• ✭✭✭✭✭
Options

Hello @Sara.Planchon

Give this formula a shot and let me know if it works for you:

=IF([Date of Hire]@row <> "", YEAR(TODAY()) - YEAR([Date of Hire]@row) - IF(TODAY() < DATE(YEAR(TODAY()), MONTH([Date of Hire]@row), DAY([Date of Hire]@row)), 1, 0), "")

Options

THAT WORKED! You sir are amazing! Thank you!

• ✭✭✭✭✭
Options

Excellent!

I appreciate the feedback.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!