EXCEL读取身份证信息

读取性别

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

读取年龄

=TEXT(YEAR(TODAY())-MID(F2,7,4),"0岁")

读取生日

=TEXT(MID(F2,7,8),"0年00月00日")

读取生肖

=MID("鼠牛虎兔龙蛇马羊猴鸡狗猪",MOD(YEAR(K2)-4,12)+1,1)