How to calculate tenure (years of service) between 2 dates?
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?
Tags:
Answers
-
I know there is a few ways to do that,
- by counting the days and dividing by 365: =(enddate@row - startdate@row) / 365
- 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.
-
It looks like your Years of Service column is set to a date type. Try changing it to a text/number type.