身份证提取详细信息 - 君相见的博客

提取出生年月
=TEXT(MID(B2,7,8),"00-00-00")
提取年龄
=DATEDIF(TEXT(MID(B2,7,8),"00-00-00"),TODAY(),"y")
提取性别
=IF(MOD(MID(C2,17,1),2),"男","女")

文章评论