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
=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
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
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
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.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls