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