Home

Calculating retirement date based on job start date

%3CLINGO-SUB%20id%3D%22lingo-sub-868004%22%20slang%3D%22en-US%22%3ECalculating%20retirement%20date%20based%20on%20job%20start%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868004%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20calculate%20the%20date%20of%20retirement%20based%20on%20the%20date%20of%20entry%20to%20the%20job.%3C%2FP%3E%3CP%3E-%20If%20they%20entered%20on%20or%20before%202012-12-31%20they%20are%20elgigible%20to%20retire%20at%20age%2060.%3C%2FP%3E%3CP%3E-%20If%20they%20started%20work%20on%20or%20after%202013-01-01%2C%20they%20can%20retire%20at%20age%2065.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20that%20I'm%20trying%20is%20sometimes%20working%20and%20other%20times%20not%3A%3CBR%20%2F%3E%3DIF(G7%26gt%3B%3D2013%2CEDATE(I7%2C12*65)%2CEDATE(I7%2C12*60))*OR(IF(G7%26lt%3B%3D2012%2CEDATE(I7%2C12*60)%2CEDATE(I7%2C12*65)))%3CBR%20%2F%3EPlease%20help.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-868004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-868104%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20retirement%20date%20based%20on%20job%20start%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868104%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412625%22%20target%3D%22_blank%22%3E%40lamaza71%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20formula%20instead%3A%3C%2FP%3E%3CPRE%3E%3DIF(F7%26lt%3B%3DDATE(2012%2C12%2C31)%2CEDATE(H7%2C12*60)%2CEDATE(H7%2C12*65))%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132801iE33E9DA111FD955F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Retirement%20Date.png%22%20title%3D%22Retirement%20Date.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
lamaza71
Occasional Visitor

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

@lamaza71

 

Hi,

 

Try this formula instead:

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

Retirement Date.png

 

Regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies