I want Exect Retirement date

[Syed Shakeel Ahmed]

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

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

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

 

[Syed Shakeel Ahmed]

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

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

<TBODY>
</TBODY>

I want Exact date of retirment

 

[dave3009]

=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.

 

[Biz]

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