Calculate program qualification

[silentdragonfly]

Our employees are offered a retirement benefit based on the following criteria:
1. must be full time
2. must attain 15 years of consecutive service
3. must achieve one of the following:
a. if age is between 55 and 61 and combination of age and years of service is greater than or equal to 85
b. if age is between 62 and 64 and combination of age and years of service is greater than or equal to 82
c. if age is over 65 and have at least 15 years of consecutive years of service

I have a database of Name, Date of Hire, DOB. I've figured out how to calculate who is eligible but am getting stuck with projecting when they would qualify in the future. Here are 2 examples. The first EE calculates appropriately but since the 2nd doesn't qualify until sometime in the future, it should add one year to the EE's age and one year to the EE's years of service until they reach the requirements in #3 above. This is the part I am stuck on.

Can anyone help?

Name	DOH	DOB	When qualified?
EE1	9/24/1986	8/10/1960	Qualified 2017
EE2	12/26/1989	1/1/1965

<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;"> <tbody> </tbody>

 

[silentdragonfly]

I forgot to add the columns and formulas I already have.

First I have a column that calculates both the EE's age and YOS: =INT((Info!f1-f2)/365)
Then a column that determines if the EE is eligible (it excludes part timers)
Then a column that calculates whether they are between 55 & 61: =IF(And(g2>=Info!c6,G2<=Info!e6),"YES","NO")
Then the same to calculate whether they are between 62 & 64
Then a column to calculate whether they are over 65: =IF(g2>Info!c7,"YES","")
Then a column to add the age and YOS together.
And finally a column to determine if the employee (EE) currently qualifies: =IF(AND(i2="ELIGIBLE",j2="YES",M2>=Info!f6),"QUALIFIED","NOT QUALIFIED")

I'm guessing there's a much easier way to write the formula in one cell but this helped my mind work through the criteria.