F68为身份证号码所在单元格
=IF(MOD(RIGHT(LEFT(F68,17),1),2),"男","女")
=YEAR(TODAY())-MID(F68,7,4)
=TEXT(MID(F68,7,8),"0000年00月00日")
F68为身份证号码所在单元格
=IF(MOD(RIGHT(LEFT(F68,17),1),2),"男","女")
=YEAR(TODAY())-MID(F68,7,4)
=TEXT(MID(F68,7,8),"0000年00月00日")
本文标题：excel根据身份证号生成性别、出生日期、年龄
本文链接：https://www.haomeiwen.com/subject/wkmbdktx.html
网友评论