Need Help With Excel to calculate retirement age

I am trying to create a sheet on excel in which I need to calculate the retirement date. The condition being that the employee gets retired if he is either 58 years of age or has worked in the company for 25 years(which ever is earlier). Till now I have used
=DATEDIF(D2,TODAY(),"Y") :for calculating age and for calculating work exp.
=IF(OR(F2>=58,G2>=25),"RETIRED","YEARS LEFT") : for knowing whether the employee is retired or years are left.
Now I want to calculate the date for the retirement.
WAITING FOR URGENT RESPONSE.
Kindly guide me through.
Regards.
Tapanjyoti
6th December 2008 From India, Bhopal

Hi,
Great to see u use the datedif() function.
You can do the following:
For 58 yrs criteria:
Here A1 contains the DOB of the employee in dd-mmm-yy format
=DATE(YEAR(A1)+58,MONTH(A1),DAY(A1))
For 25 years criteria, replace 58 in the above formulae by 25, you will get a date 25 years hence.
Regards,
Niilesh
8th December 2008 From India, Mumbai

Hope this helps.... Nilesh
8th December 2008

Attached Files (Download Requires Membership)

excel function dictionary.xls (1.10 MB, 2962 views)

This formula works fine, but in my organisation date of retirement is the last day of the month the attaining the age 60 years. Plz provide formula for it
28th June 2010 From India, Bharat