(Formula) Calculating Earliest Retirement Date

[dallascowboys]

Hi All,

I need some help to calculate earliest retirement date.

I have DOB (A1) and Date of Hire (B1)
earliest retirement requires age of 60 plus 10 years service.

Would like to have a date return from the formula.

Thank you all!

 

[gaz_chops]

Maybe

=MAX(EDATE(A1,720),EDATE(B1,120))

 

[dallascowboys]

Maybe

=MAX(EDATE(A1,720),EDATE(B1,120))

this is not the earliest though, because if you hit age 65, then you can retire anyway.

 

[gaz_chops]

"earliest retirement requires age of 60 plus 10 years service".

 

[jtakw]

Hi,

So are you saying, if I was hired yesterday, and today is my 65th birthday, I retire today?

Also, please clarify the age 60 and age 65 difference.

 

[gaz_chops]

Not tested

=MIN(MAX(EDATE(A1,720),EDATE(B1,120)),EDATE(A1,780))

 

[dallascowboys]

Not tested

=MIN(MAX(EDATE(A1,720),EDATE(B1,120)),EDATE(A1,780))

I got it, this is what i used
=MIN(EDATE(A2,780),MAX(EDATE(A2,720),EDATE(B2,120)))

 

[gaz_chops]

You're welcome.