本帖最后由 gaozengxun 于 2024-9-19 23:19 编辑
这里我前两天也做了一个,供大家共勉,参考。
新政退休日期=EDATE(EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),MIN(CEILING(DATEDIF("2024-12-1",EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),"M")/IFS($E6+$F6,4,$G6,2),1),IFS($E6,3,$F6,3,$G6,5)*12))
工龄=EDATE(EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),MIN(CEILING(DATEDIF("2024-12-1",EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),"M")/IFS($E6+$F6,4,$G6,2),1),IFS($E6,3,$F6,3,$G6,5)*12))
改革后法定退休年龄=EDATE(EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),MIN(CEILING(DATEDIF("2024-12-1",EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),"M")/IFS($E6+$F6,4,$G6,2),1),IFS($E6,3,$F6,3,$G6,5)*12))
延迟月数=EDATE(EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),MIN(CEILING(DATEDIF("2024-12-1",EDATE($D6,IFS($E6,60,$F6,55,$G6,50)*12),"M")/IFS($E6+$F6,4,$G6,2),1),IFS($E6,3,$F6,3,$G6,5)*12))
|