# (Formula) Calculating Earliest Retirement Date

#### dallascowboys

##### New Member
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!

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Maybe

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

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.

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

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.

Not tested

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

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)))

You're welcome.

Replies
7
Views
217
Replies
1
Views
126
Replies
12
Views
364
Replies
22
Views
363
Replies
4
Views
330

1,203,242
Messages
6,054,353
Members
444,718
Latest member
r0nster

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back