To calculate the retirement date in excel, there is a very easy way. 

Previously: How to group by numbers using VLOOKUP formula?

Let’s take an example to elaborate for what you should do to calculate the retirement date.

Calculate retirement date

All you need is DOB, we have taken Name as it’s an obvious that if you don’t have the names you will get confused.

Calculate retirement date

The function used to find out the retirement date is EDATE.

=EDATE(

The following formula requires start date, and months.

Calculate retirement date

Our start date will be our date of birth, so in this case 12-03-2000 is the start date i.e. cell D3.

Calculate retirement date

Then comes the months, now as well know that a person generally retires at the age of 60, and one year consists of 12 months so we will input 12*60 in the months.

Calculate retirement date

Now press “enter”. 

The answer is right in front of you. The retirement date for Sarah is 12 March, 2060. 

Now all you have to is drag the formula down so that it becomes easier for you to bring the result for the other entries as well.

Calculate retirement date

So, it’s easy, isn’t it?