calculate years of completed service

[#1]

I am trying to get years of service for employees - I have got the HireDate field - which function should  I sue to calculate years of completed service?

TIA

[antoniotiman · Accepted solution]

Hi Soumya,

maybe

=Date(Today()-Date(HireDate) ,'YY-MM')

e.g.

=Date(Today()-Date('01/01/2012') ,'YY-MM')

Regards,

Antonio

[#3]

Hi @Antonio

Thank you - I took inspiration from the formula you provided and used the following:

Year(Today())- year([Hire Date])

It is working