根据身份证计算年龄：
=YEAR(TODAY())-MID(A4,7,4)

根据身份证辨别性别
=IF(MOD(MID(A4,17,1),2),”男”,”女”)