Shared publicly  - 
 
Formula Friday: Calculate retirement date in #Excel http://bit.ly/2bTagFI
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.
1
Add a comment...