Excel Magic Trick 1147

Incorrect Formula To Calculate Retirement Year


See how to:
(00:07) 80 Rule For Retirement Age
(00:48) Formula for Year of Retirement using YEAR function.
(01:09) 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)
(01:36) Formula to calculate Retirement Date based on 80 Rule using EDATE function.


Be the first to comment

Leave a Reply