延遲后退休日計算 分男女 (14238)

G2=TEXT("2025-1-1"-SUBSTITUTE(C2,".","-"),"Y")+TEXT("2025-1-1"-SUBSTITUTE(C2,".","-"),"M")/12

H2=INT((55-(B2=B$2)*5-G2)*12/(4-(B2=B$2)*2))

D2=EDATE(SUBSTITUTE($C2,".","-"),(55-($B2=$B$2)*5)*12)

E2=EDATE(D2,H2)



留言