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.
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.
The function used to find out the retirement date is EDATE.
The following formula requires start date, and months.
Our start date will be our date of birth, so in this case 12-03-2000 is the start date i.e. cell D3.
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.
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.
So, it’s easy, isn’t it?