Shared publicly  - 
Formula Friday: Calculate retirement date in #Excel
To calculate a retirement date based on a birth date, you can use the EDATE function. In the example shown, the formula in D6 is: =EDATE(C6,12*60) How this formula works The EDATE function is fully automatic, and will return a date xx months in the future or past, when given a date and the number of months to traverse.
Add a comment...