Excel根据身份证号码判断男女、年龄信息

假设身份证号码在C列

判断男女:

=IF(MOD(MID(C2,17,1),2)=1,"男","女")

计算年龄:

=YEAR(TODAY())-MID(C2,7,4)

计算出生年月:

=CONCATENATE(MID(C2,7,4),"-",MID(C2,11,2),"-",MID(C2,13,2))