Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Soumya,
maybe
=Date(Today()-Date(HireDate) ,'YY-MM')
e.g.
=Date(Today()-Date('01/01/2012') ,'YY-MM')
Regards,
Antonio
Hi Soumya,
maybe
=Date(Today()-Date(HireDate) ,'YY-MM')
e.g.
=Date(Today()-Date('01/01/2012') ,'YY-MM')
Regards,
Antonio
Hi @Antonio
Thank you - I took inspiration from the formula you provided and used the following:
Year(Today())- year([Hire Date])
It is working