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
Acknowledge(0)
Amend(0)
=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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
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