Rule of 75 Retirement Calculation
BAD wrote:
I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?
Birth date in A1, hire date in A2
=(27394-(A2-A1))/2+A2
|