# I want Exect Retirement date

#### Syed Shakeel Ahmed

##### New Member
I want formula which exect date employee retired (Comapny policy 60 years a person has retired.

 Employees DOA DOB Current Date Years AGE Duration of Services Exact Retirement Date A 26-May-96 2-Jan-53 3-Jul-12 59.5 16.1 B 26-May-96 7-Jul-53 3-Jul-12 59.0 16.1 C 26-May-96 1-Jan-54 3-Jul-12 58.5 16.1 D 26-May-96 1-Jan-54 3-Jul-12 58.5 16.1 E 26-May-96 20-Dec-55 3-Jul-12 56.6 16.1 F 26-May-96 1-Jan-56 3-Jul-12 56.5 16.1 G 26-May-96 1-Jan-69 3-Jul-12 43.5 16.1 H 1-Apr-07 29-Aug-77 3-Jul-12 34.9 5.3 I 8-May-08 5-Oct-77 3-Jul-12 34.8 4.2

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
I want formula which exect date employee retired (Comapny policy 60 years a person has retired.

 Employees DOA DOB Current Date Years AGE Duration of Services Exact Retirement Date A 26-May-96 2-Jan-53 3-Jul-12 59.5 16.1 B 26-May-96 7-Jul-53 3-Jul-12 59.0 16.1 C 26-May-96 1-Jan-54 3-Jul-12 58.5 16.1 D 26-May-96 1-Jan-54 3-Jul-12 58.5 16.1 E 26-May-96 20-Dec-55 3-Jul-12 56.6 16.1 F 26-May-96 1-Jan-56 3-Jul-12 56.5 16.1 G 26-May-96 1-Jan-69 3-Jul-12 43.5 16.1 H 1-Apr-07 29-Aug-77 3-Jul-12 34.9 5.3 I 8-May-08 5-Oct-77 3-Jul-12 34.8 4.2

<TBODY>
</TBODY>
I want Exact date of retirment

=DATE(YEAR(C2)+60, MONTH(C2), DAY(D2))

Ought to give you 60 years to the birthday, assuming the DOB is in C2. You can copy this down.

Very similar to dave but not hard coding 60 in formula
Cell H1 is input of retirement age.

=DATE(YEAR(C2-1)+\$H\$1,MONTH(C2-1)+1,DAY(C2))

Replies
0
Views
345
Replies
6
Views
3K
Replies
1
Views
193
Replies
7
Views
474
Replies
1
Views
613

1,203,061
Messages
6,053,307
Members
444,651
Latest member
markkuznetsov1

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