xtremetapan
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

From India, Bhopal
n_bhoite
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

From India, Mumbai
p_nileshg1
Hope this helps.... Nilesh
Attached Files (Download Requires Membership)
File Type: xls excel function dictionary.xls (1.10 MB, 2979 views)

nkc63
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
From India, Bharat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.