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

06/15/21
Answered - Pending Review

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,

    1. by counting the days and dividing by 365: =([email protected] - [email protected]) / 365
    2. by counting the years and get a solid number: =YEAR([email protected]) - YEAR([email protected])

    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 NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

Sign In or Register to comment.