Compute Tenure date to TODAY

Hello-

Can you assist me with the formula for the # of years and month?

Hiring Date is Oct 17, 2002 === What is the years and months of Tenure

Best Answer

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Answer ✓

    I'm so sorry! Can't believe I missed that step. This should do it:

    • =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"


    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

Answers

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭

    Hi,

    Assuming you have a [Hiring Date] column you could use a formula like:

    • =ROUND((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUND((TODAY()-[Hiring Date]@row)/30) + "Months"

    This isn't exact as there are not 30 days in every month, but it gives you a close approximation. The formula to get the exact number of months would be slightly more complicated.

    Hope this helps!

    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

  • @Zachary Hall

    The result is 22 Years 271Months from your formula.... What I need is... for Oct 17, 2001 ---22 years 3 months Thanks.

  • Zachary Hall
    Zachary Hall ✭✭✭✭✭✭
    Answer ✓

    I'm so sorry! Can't believe I missed that step. This should do it:

    • =ROUNDDOWN((TODAY()-[Hiring Date]@row)/365)+" Years " + ROUNDDOWN((TODAY() - [Hiring Date]@row) / 30 - (ROUNDDOWN(((TODAY() - [Hiring Date]@row) / 30) / 12) * 12)) + "Months"


    Best,

    Zach Hall

    Training Delivery Manager / Charter Communications

  • khelland
    khelland ✭✭✭

    This unfortuniatly didn't caluclate properly. as an example, someone with an anniversary date of 1/13/2003, using this formula returned 22 years and 4 months yet today is only 2/6/2025 which is 22 years and 24 days.

    Date difference from Jan 13, 2003 to Feb 6, 2025

    https://www.convertunits.com/dates/from/Jan%2B13%2C%2B2003/to/Feb%2B6%2C%2B2025

    How can we fix this to reflect properly?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!