Years of Service Formula Help

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.


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!