Years of Service Formula Help

Sara.Planchon

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.

=Chris Palmer

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), "")

Sara.Planchon

THAT WORKED! You sir are amazing! Thank you!

=Chris Palmer

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), "")

Sara.Planchon

THAT WORKED! You sir are amazing! Thank you!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/411692#Comment_411692

Excellent!

I appreciate the feedback.