hi

=datedif(hiredate,todaydate,"Y")

it will return you the difference in completed years

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ricter" escreveu:

If I have an employee database with hire dates, and a company longevity award
program that gives an award for each 5th year anniversary, ie. 5, 10, 15,
etc. years of service, what formula could I use to flag every record/row
where an employee is entitled to an award, or not, in the coming 12 months?

tia