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.
Try this formula instead: