How to calculate tenure (years of service) between 2 dates?

Elisa Hogan

Hello, I am trying to get a date on the Years of service column. In excel you just minus today's date-start date and it will give you a result with smart sheets I can't figure out how to do it. Can somebody help me?

Alex Argumedo

I know there is a few ways to do that,

1. by counting the days and dividing by 365: =(enddate@row - startdate@row) / 365
2. by counting the years and get a solid number: =YEAR(enddate@row) - YEAR(startdate@row)

There is other date manipulation functions you could use,

Important: I see in your screenshot you are trying the formula in a date column, this formulas will fail on that column because are not dates but numbers.

Paul Newcome

It looks like your Years of Service column is set to a date type. Try changing it to a text/number type.