Look Who it Was Random video

Excel Magic Trick 1147: Incorrect Formula To Calculate Retirement Year

3,771 views · Published 6 November 2014 · 2:27 · Indexed 4 November 2026

Channel: excelisfun · 2014 · Education

Watch on YouTube

Download Excel Start File: https://excelisfun.net/files/EMT1147.xlsx

Download Excel File: https://excelisfun.net/files/ExcelIsFun.htm
See how to:
1. (00:07 minute mark) 80 Rule For Retirement Age
2. (00:48 minute mark) Formula for Year of Retirement using YEAR function.
3. (01:09 minute mark) Wipe away Date Number Format by applying the General Number Format. See the keyboard for General Number Formatting: Ctrl + Shift + `~ (key to left of Number 1 key on normal Number Pad)
4. (01:36 minute mark) Formula to calculate Retirement Date based on 80 Rule using EDATE function.

More from this channel