Retirement Eligibility Date based on 3 Variables

clabulis,

Once again, I can't think you enough.

Over the past week I had an opportunity to play with a list of employees and create a TEST worksheet. The formula works exactly as needed for some, but not correctly for some others. I have attached the entire list with a few of the examples noted as I haven't been able to track down what in the formula is not working correctly for some.

Those with your GREEN formula on the list meet the criteria for:

1. 50 years of age AND at least 20 years of service

2. 55 years of age AND at least 10 years of service

3. Any Age AND at least 25 years of service

Those listed below the black bar with your BLUE formula are those employees who meet the criteria for:

1. 60 years of age AND at least 10 years of service

2. 65 years of age AND at least 5 years of service

3. Any Age AND at least 30 years of service

Thank you again for taking the time to create this formula and help me out.


Dale