【分享】全国行政区域身份证代码表

=IF(A2="","",IF(-1^RIGHT(LEFT(A2,17))>0,"女","男"))性别

=IF(A3="","",IF(MOD(MID(A3,17,1),2),"男","女"))省份=IF(A2="","",INDEX(全国地区代码表!B:B,MATCH(LEFT(A2,2)& =IF(A3="","",VLOOKUP(LEFT(A3,2)&"0000",全国地区代码表!A 籍贯=IF(A2="","",INDEX(全国地区代码表!B:B,MATCH(LEFT(A2,6), =IF(A3="","",LOOKUP(LEFT(A3,6),全国地区代码表!A:A,全国地出生日期=IF(A2="","",TEXT(TEXT(MID(A2,7,LEN(A2)/2-1),"0-00-00") =IF(A3="","",IF(LEN(A3)=15,TEXT(19&MID(A3,7,6),"0年00月年龄=IF(A2="","",DATEDIF(E2,TODAY(),"y")&"岁")

=IF(A3="","",YEAR(TODAY())-YEAR(E3)&"岁")

T(LEFT(A2,17))>0,"女","男"))

(A3,17,1),2),"男","女"))

地区代码表!B:B,MATCH(LEFT(A2,2)&"0000",全国地区代码表!A:A)))

FT(A3,2)&"0000",全国地区代码表!A:B,2,))

地区代码表!B:B,MATCH(LEFT(A2,6),全国地区代码表!A:A)))

T(A3,6),全国地区代码表!A:A,全国地区代码表!B:B))

MID(A2,7,LEN(A2)/2-1),"0-00-00"),"yyy年m月d日"))

=15,TEXT(19&MID(A3,7,6),"0年00月00日"),TEXT(MID(A3,7,8),"0年00月00日"))) ,TODAY(),"y")&"岁")

())-YEAR(E3)&"岁")

TRUE

TRUE

00",全国地区代码表!A:A)))

国地区代码表!A:A)))

代码表!B:B))

yy年m月d日"))

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