Rule of 75 Retirement Calculation
I think with the person's name in column A, birthdate in column B, and hire
date in column C and row 1 containing headers, in column D row 2:
=(2*Today()-B2-C2)/365.25
gives you what you are looking for.
"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?
|