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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!