Excel怎么计算退休剩余时间?答:",,DATEDIF(TODAY(),G2,{"Y","YM","MD"})&{"年","月","日"})或 =DATEDIF(TODAY(),G3,{"Y","YM","MD"})&{"年","月","日"} 下拉填充 通用版本,可用如下公式 =DATEDIF(TODAY(),G3,"Y")"年"&DATEDIF(TODAY(),G3,"YM")&"月"&DATEDIF(TODAY(),G3,"MD")&"日"...
excel表格怎么用身份证号算退休年月答:=DATE(MID(A2,7,4)+IF(MOD(MID(A2,17,1),2),60,55),MID(A2,11,2),MID(A2,13,2))下拉填充 将B列设置为日期格式。这里没考虑15位身份证的情况,如果需要再改。补充:J2公式 =TEXT(DATE(MID(B2,7,4)+IF(MOD(MID(B2,17,1),2),60,55),MID(B2,11,2),MID(B2,13,2)),"e...