Retirement Eligibility Date based on 3 Variables

Looks like I mixed up a MIN with a MAX in the original formula. I made a new column called "EDITED" where you'll see my revised formula (compare it to the original by dragging your formula bar all the way down and clicking back and forth between my original column and the new one and you'll see the change I made).

All of my new results match up with your notes. My formula for row 7 seems to grab a slightly earlier date than the one mentioned in your note so I would just double-check everything just to be sure.

I've supplied edited versions for both types of employees as well.

Hopefully this is the only issue that we should come across. Let me know if you find anything else