Need Help With Excel to calculate retirement age - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
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

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

Hope this helps.... Nilesh

Attached Files
 Membership is required for download. Create An Account First excel function dictionary.xls (1.10 MB, 2873 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
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.