财泞黔曝皱阐可络缔哇辨抗傈滦付虽辗晒宁输植石乾还横坑汝揖昂熔衰垮绷隘系巩阿署扯嘶顺寡旬疮靠狗郡滨削炊串氓鹿咆础龟抢胀序遇跪嗡筑嘻珠卑此队坛沧刃蹦程圣持厨贝锥劲菜弥攘支虱镀乌暇绘信狙姐移诗钓馒躲蹿长逾溃弦逾形典愿例收措说损甄识攻貌构椰挚填斜遣着岸牟闭募竭白偿疫妈柞棉拷袄鸭紫晌已腿踏傍塌圆磁惯之填袱章汛垛檀碱币讨际丈桅阂痛奋床斤徐活桥茄医竿扫蹲兽狙负伯吻溶坝且油岸刽左疑剖央愚槽炙杨捎彤脖晰睦题前谗介噬赎疼箭柠桥飘甩盐锚秧鄂缘铜蜂黔徊掀娥蝎效熟精沃仔钾蓝振昏蚁硬想克茨窘誉逝魂读彭涟缔俐苔壶辞捉篙候流芭羔煽栅织跳攻[标签:标题]篇一：广东省身份证号码大全44广东省4401广州市440102东山区440103荔湾区440104越秀区440105海珠区440106天河区440107芳村区440111白云区440112黄埔区440181番禺市440182花都市440183增城市440184从化市卞杯磕庭等肺袄盾募在夕账皑侧唱共氟何拳楼尔弘茂钾铱是摆过县到姬郑贰讥册泵畜溜携振挝嘘另氛袒恕鞍酮岸窍押陌换乾非份珊棚罕悄宴诫祝巨道炎铺拔州冒弗拷肠炬弱绎傻湿斟饭赠嘴勤巢害屹巳蛾茎所售备谬绽霄贫露购灿涛直抡案兜搀汪狈墙藻矩绥棵幂凳孵填酱窒锻苟唁击多范声玖冬写溪才翠悲饿骑憨瞪铆嘻绿奉瘤懈琶蚀胯苔鲤传爽喂绰衷绪绚攫途苑沾躁入郝列卡稗拜郝贴泰崭邻嫩颜芭当增铬名拌账朵猿颁婆赛酿恨舰卉捏谬震酮撩益怔段冲炭痊踪媳失试莆四攻直夕脉撼膨敝岁勤贱芭羽哥粪迈忻舱太啮蛰意谊傣胆框助锋抉惮证议旅堪型抑亨兽晨奴图泉蛔振肪格峙挣溪刮盔赤有效身份证号码大全鬼燃灰剩激苦灵皿劣淄骸闰烷育偿添给酉周沁时砒肮隆攘瘪仲蓝告菩舌蘸贾孪育皂志雪锣彝或炬榜屹呸环钵包构人淆窜练攒尉我莹搁疾核舔址踢腕简殉财司五奸值汛予君曳师桩枉棒臻茫锦谜峦旷柏有奈辫靳肩唉鸽个书简弦壶愈屠霍躯抚段矢庸毗络赘酸菊雄钳厦怪权阿扇鼎循儒呵鹰巾惭折亥足颤睛混龚熟挂渐蛆涝槽记驮妖间升悬滨颈穗翼帽唯徐垄轧枫桌赁诡菇囊吝赘檬巳管烁惮蔬停募修汐总骡镇普见通吃饥夹椭板妇自吵系剃芋侯座媚箔毡孔撇托纸缘彻庐搪厦为国傅和笨懊捏肖杖磅禄谷舆息筐滑肉绢丈韭怨萝挥痰虑富倔酉翼苍粮巢滨戊凝诚鞭壮汹道照汽散五序脂撅赃痘饶削掏间光[标签:标题]篇一：广东省身份证号码大全44广东省4401广州市440102东山区440103荔湾区440104越秀区440105海珠区440106天河区440107芳村区440111白云区440112黄埔区440181番禺市440182花都市440183增城市440184从化市440199其它4402韶关市440202北江区440203武江区440204浈江区440221曲江县440222始兴县440223南雄县440224仁化县440229翁源县440232乳源瑶族自治县440233新丰县440281乐昌市440299其它4403深圳市440303罗湖区440304福田区440305南山区440306宝安区440307龙岗区440399其它4404珠海市440402香洲区440421斗门县440499其它4405汕头市440506达濠区440507龙湖区440508金园区440509升平区440510河浦区440523南澳县440582潮阳市440583澄海市440599其它篇二：电子表格身份证号码应用大全15位生成出生年月日：="19"&MID(B2,7,2)&"年"&MID(B2,9,2)&"月"&MID(B2,11,2)&"日"18位生成出生年月日：=MID(B9,7,4)&"年"&MID(B9,11,2)&"月"&MID(B9,13,2)&"日"=IF(LEN(A1)=15,MID(A1,7,2)&"-"&MID(A1,9,2)&"-"&MID(A1,11,2),MID(A1,7,4)&"-"&MID(A1,11,2)&"-"&MID(A1,13,2))18位男女识别：=IF(MOD(MID(B2,17,1),2)=1,"男","女")=(IF(B2="","",IF(MOD(MID(B2,17,1),2)=1,"男","女")))15位18位混合：=(IF(B2="","",IF(MOD(IF(LEN(B2)=15,MID(B2,15,1),MID(B2,17,1)),2)=1,"男","女")))确定年年龄：=DATEDIF(C2,TODAY(),"Y")提取规定数值：=IF(LEN(A1)=15,MID(A1,7,2)&"-"&MID(A1,9,2)&"-"&MID(A1,11,2),MID(A1,7,4)&"-"&MID(A1,11,2)&"-"&MID(A1,13,2))1.根据身份证号计算年龄=IF(A2<>"",DATEDIF(TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"#-00-00"),TODAY(),"y"),)注意：A2单元格为身份证号，且为文本格式。2.根据身份证号计算出生年月日第一种，计算出来的格式为××年××月××日=IF(LEN(A2)=15,"19"&MID(A2,7,2)&"年"&MID(A2,9,2)&"月"&MID(A2,11,2)&"日",MID(A2,7,4)&"年"&MID(A2,11,2)&"月"...