Rule of 75 Retirement Calculation
Glenn wrote:
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
Don't forget to format the result as a date.
|