I'm sorry it says its about 4 months off.

My bday is 10/01/80. My hire date is 06/05/06. With the rule of 75 I
should be eligible to retire on June 4, 2031 (On that date, I will complete
25 yrs of service and will be 50 yrs old). Your formula is giving me the
date 02/01/2031. Unless I am doing something wrong???? Thanks again for
your help

"~L" wrote:

That's interesting. What combination of values did not produce the expected
result?

"BAD" wrote:

Thanks but I am still about a year off using your formula.

"~L" wrote:

Err... I guess it would help if I did the algebra on that.

=TEXT((27393.75+B2+C2)/2,"mm/dd/yyyy")

"~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?