Forum Discussion
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 after 2013-01-01, they can retire at age 65.
The formula that I'm trying is sometimes working and other times not:
=IF(G7>=2013,EDATE(I7,12*65),EDATE(I7,12*60))*OR(IF(G7<=2012,EDATE(I7,12*60),EDATE(I7,12*65)))
Please help. Thank you.
1 Reply
Hi,
Try this formula instead:
=IF(F7<=DATE(2012,12,31),EDATE(H7,12*60),EDATE(H7,12*65))
Regards
