Years of Service with Company - Date Formula - Help needed

Using this formula to calculate the Years of Service, but the formula is rounding up.

For instance, 7/18/22 is returning 2 years of service when it wont be 2 years until 7/18/24

=YEAR(TODAY()) - YEAR([Hire Date]@row)

Answers

  • PM_Reeves
    PM_Reeves ✭✭✭✭✭

    Hi,

    I use a couple of options in one sheet.

    =ROUND(ROUND((NETDAYS([Start Date]@row, [Expiry Date]@row) / 365) * 12) / 12) + "yrs" + MOD(ROUND((NETDAYS([Start Date]@row, [Expiry Date]@row) / 365) * 12), 12) + "mo" (Not my formula)

    is the first one I use, but if you only want years

    a combination of

    =[Expiry Date]@row - [Start Date]@row

    and

    =[Term Days]@row / 365

    work for me - then I just hide these columns