Rule of 75 Retirement Calculation
same deal here...This gives me a date of march/1900. It should be a future
date.
"~L" wrote:
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?
|