Years of Service with Company - Date Formula - Help needed

JHigginbotham

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)

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