Supposing, an employee will be retired at the age of 60, how could you calculate the retirement date from the date of birth in Excel? Today I introduce you to some formulas to solve this problem. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- Use the below formula to calculate the retirement date from the date of birth in Excel.
=EDATE(A1,12*60)
Syntax Explanations:
- EDATE – In Excel, the EDATE function helps to add or subtract the specified number of months with the given date and returns the serial number that represents the result date in Excel.
- A1 – It represents the input date.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- *Multiplication (*) *– In this symbol will multiply any two values or numbers.
Practical Example:
Refer to the below example image.
- First, we will enter the input names and date of birth in Column B and Column C.
- Now we are going to calculate the retirement date based on their date of birth.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
- If you just want to know the number of years to retire from the current date, you can use the below formula.
- Apply the above-given formula, you can get the below result.
Conclusion:
Here, we have described the simple formula used to calculate the retirement date from the date of birth in Excel. If you feel this article is useful, then leave feedback in the below comment section. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)