Forum Discussion
lamaza71
Sep 20, 2019Copper Contributor
Calculating retirement date based on job start date
I'm trying to calculate the date of retirement based on the date of entry to the job. - If they entered on or before 2012-12-31 they are elgigible to retire at age 60. - If they started work on or ...
Haytham Amairah
Sep 20, 2019Silver Contributor
Hi,
Try this formula instead:
=IF(F7<=DATE(2012,12,31),EDATE(H7,12*60),EDATE(H7,12*65))
Regards