延迟退休年龄计算表

gaozengxun

这里我前两天也做了一个，供大家共勉，参考。



新政退休日期=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))

gaozengxun

这里图片贴上，比较直观

dahuan

群内高手如云，赞一个！

ericxzhou

Python+Pandas:
import pandas as pd
from dateutil.relativedelta import relativedelta
import math

df = pd.read_excel('pandas exercise/sample482.xlsx', '计算表', usecols='b:g', header=1, nrows=12)
def f(s):
    b_date = s['出生日期']
    o_r_age = s['原法定退休年龄']
    k_date = pd.Timestamp('2025-1-1')
    divider = 4 if o_r_age == 60 or o_r_age == 55 else 2
    o_r_date = b_date + relativedelta(years=o_r_age)
    d_month = math.ceil(((o_r_date.year - k_date.year) * 12 + o_r_date.month) / divider)
    if d_month > 0:
        if (o_r_age == 60 or o_r_age == 55) and (d_month > (12 * 3)):
            d_month = 12 * 3
        elif (o_r_age == 50) and (d_month > (12 * 5)):
            d_month = 12 * 5
        return o_r_date + relativedelta(months=d_month)
    else:
        return o_r_date
df.iloc[:, -1] = df.apply(f, axis=1)
df