1 身份证计算年龄 =DATEDIF(TEXT(MID(A1,7,8),"#-00-00"),TODAY(),"Y") 2 身份证计算性别 =IF(MID(B3,17,1)/2=TRUNC(MID(B3,17,1)/2),"女","男")