法定退休年龄计算器

法定退休年龄计算器

法定退休年龄计算器

全部公式已列出：

出生日期：=--TEXT(B5,"0000")&"/"&TEXT(C5,"00")&"/"&TEXT(D5,"00")

性别公式：=IFS(C8="男职工","男",C8="原法定退休年龄55周岁女职工","女",C8="原法定退休年龄50周岁女职工","女")

原法定退休年龄：=IFS(AND(C8="男职工",H5="男"),60,AND(C8="原法定退休年龄55周岁女职工",H5="女"),55,AND(C8="原法定退休年龄50周岁女职工",H5="女"),50)

原法定退休日期：=EDATE(G5,I5*12)

延迟开始日期：=IFS(AND(C8="男职工",H5="男"),"1965/1/1",AND(C8="原法定退休年龄55周岁女职工",H5="女"),"1970/1/1",AND(C8="原法定退休年龄50周岁女职工",H5="女"),"1975/1/1")

延迟间隔：="每"&IFS(AND(C8="男职工",H5="男"),4,AND(C8="原法定退休年龄55周岁女职工",H5="女"),4,AND(C8="原法定退休年龄50周岁女职工",H5="女"),2)&"个月延迟1个月"

延迟退休月数：=MIN(CEILING(MAX(12*(YEAR(G5)-1964-((H5="女")+(I5=50)*(H5="女"))*5)+MONTH(G5)-12,0)/IF(AND(H5="女",I5=50),2,4),1),36+(I5=50)*(H5="女")*24)

延迟退休日期：=EDATE(G5,I5*12+I8)

人员类型：数据有效性，允许：序列，来源：男职工,原法定退休年龄55周岁女职工,原法定退休年龄50周岁女职工