Calculating retirement date based on job start date

[lamaza71]

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.

[#2]

@lamaza71

Hi,

Try this formula instead:

=IF(F7<=DATE(2012,12,31),EDATE(H7,12*60),EDATE(H7,12*65))

Regards