距退休天數 日期 (8974)

 

  C2=TEXT(EDATE(TEXT(MID(B2,7,8),"00-00-00"),12*(55+MOD(MID(B2,17,1),2)*5))-F$2,"0;已退休")

D2=EDATE(TEXT(MID(B2,7,8),"00-00-00"),12*(55+MOD(MID(B2,17,1),2)*5))