how to find date of retirement

[cnu nagula]

Dear Friends,

kindly help me to solve the following problem in excel

i need a excel programme to determine the date of retirement of employees as per their date of birth.

if any employees date of is : 01-07-1990, he should be retired from service on 30-06-2048, taking 58 years of age as retirement year.

2) date of birth: 15-07-1990 date of retirement is:31-07-2048

how to calculate these,

my input in a1 is date of birth, b1 is age of retirement, the result should be in c1 adding date of birth + age of retirement.

thank you

 

[BEST88771]

Thank you for your reply - Please can I add another couple steps - example if employee member of pension scheme AA then to retire at 60 but end of the month - example birthdate 02/07/1958 retire 31/07/2018 and next step if employee member of pension scheme DD then to retire at 65 on birthday example birthdate 12/05/1955 retire 12/05/2020 - please can you advise combination of both these formulas in same cell ? thank you

 

[barry houdini]

Try this version in C1, assuming scheme type in B1

=IF(B1="DD",EDATE(A1,65*12),IF(B1="AA",EOMONTH(A1,65*12),"Error"))

 

[BEST88771]

Thank you for all your help and time with this - very helpful, and it works perfectly...