电子表格出生日期转换为年龄

1、电电子子表表格格出出生生日日期期年年龄龄周周岁岁虚虚岁岁1967.0345461967份证号码位数判断性别判断 出生年月判断出生年月判断年龄62242519821102001318男1982/11/21982-11-0230196224251985011010221985-01-106224251982092800431982-09-286224251969082644141969-08-266224251984101412721984-10-1462242519841021665X1984-10-216224251983111835301983-11-

2、186224251986031944341986-03-196224251984102138381984-10-216224251987090535331987-09-056224251982090644391982-09-066224251986072304711986-07-231405221988043045211988-04-306224251984102116211984-10-216224251985091532141985-09-156224251986022044421986-02-2062242519840923122X1984-09-23622425198407032315

3、1984-07-036224251982111244291982-11-126224251984121266231984-12-126224251981041400281981-04-146224251984051301651984-05-136224251982101912321982-10-196224251982022641201982-02-266224251978012048111978-01-2062242519830317102X1983-03-176224251979011644151979-01-166224251965050244161965-05-026224251978

4、1219441X1978-12-196224251953112844341953-11-286224251956032144111956-03-216224251979083044171979-08-306224251955030144391955-03-0162242519641216441X1964-12-1662242519741228001X1974-12-286224251979021844181979-02-186224211978020368261978-02-036224251979042744251979-04-276224241957120344131957-12-0362

5、24251977080544171977-08-056224251982111100781982-11-116224251969041500301969-04-156224251979022444171979-02-246224251979040244181979-04-026224251955031944171955-03-196224281987050900291987-05-096224251955090944171955-09-096224251984101844321984-10-186224251982091263101982-09-126224251974122244131974

6、-12-226224251983041610261983-04-166224251984101801831984-10-186224251978092744271978-09-276224251985121866661985-12-186224251981102844151981-10-286224251980040944231980-04-0962242519810916001X1981-09-166224251980121244181980-12-126224251983020700401983-02-076224251971092144311971-09-2162242519830526

7、00261983-05-266224251983111944241983-11-196224251980020144341980-02-0162242519810323441X1981-03-236224251956052144151956-05-216224251960082244171960-08-226224251977082244201977-08-226224251979060144241979-06-0162242519790318441X1979-03-186224251967103044171967-10-306224251955122644131955-12-26622425

8、1955110744311955-11-0762242519860110014X1986-01-106224251987060544261987-06-056224251978121844221978-12-186224251972031544121972-03-156224251982042551131982-04-256224251955100444331955-10-046224251982110200131982-11-026224251953110644151953-11-066224251985062038291985-06-206224251980072944391980-07-

9、296224251952070644311952-07-066201041979062503041979-06-256224251985101466441985-10-146224251984100644651984-10-066224251964102545181964-10-256224251963100944141963-10-096224251959082544141959-08-256224251980082644181980-08-266224251955012544121955-01-256224251952123051131952-12-30622425198411304491

10、1984-11-306224251977101844131977-10-186224251954111844141954-11-186224251965012344241965-01-236224251980011310301980-01-136224251982062344121982-06-236224251968092700341968-09-276224251953051544141953-05-156224251982062416121982-06-246224251980100244211980-10-026224251973010144561973-01-016224251956

11、010344171956-01-036224251954051244151954-05-126224251978122344341978-12-236224251978102344221978-10-236224251978010244151978-01-026224251964080544291964-08-056224251955071044151955-07-106224251969110744191969-11-076224251985011912401985-01-196224251984092500411984-09-2562242519741118443X1974-11-1862

12、242519630408042X1963-04-086224251984010944271984-01-0962242519580129511X1958-01-296224251952060644131952-06-066224251965012044791965-01-206224251963060944381963-06-096224251981121500151981-12-156224251962010744141962-01-076224211985072964191985-07-296224251979090144111979-09-016224251976082844421976

13、-08-286224251981102032161981-10-206224251962021544671962-02-156224251973102344181973-10-236224251966060244151966-06-0262242519570307441X1957-03-076224251979061012101979-06-106224251964030951251964-03-096224251952060744351952-06-076224251980020144501980-02-016224251963071244591963-07-1262242519540119

14、44161954-01-196224251966080244351966-08-026224251952082644191952-08-266224251981102644141981-10-266224251983021901731983-02-196224251986102886231986-10-286224251985112810201985-11-286224251958011544131958-01-156224251980121844291980-12-186224251981010841391981-01-086224251983050166211983-05-01622425

15、1956072244141956-07-226224251982091844571982-09-186224251964092848321964-09-286224251982040601641982-04-066224251964040610151964-04-066224251958082344161958-08-2362242519851227122X1985-12-276224251986012044241986-01-206224251986051106281986-05-116224251976100144921976-10-016224251978071044241978-07-

16、106224251959110344121959-11-036224251967102044591967-10-206224251984020944101984-02-096224251956041644361956-04-166224251980112844361980-11-286224251969081900131969-08-196224251969101144581969-10-116204211983040605001983-04-066224271979061737861979-06-176224251981090744291981-09-0762242519850724602X

17、1985-07-246224251983041844121983-04-186224251956100844321956-10-086224251969082644571969-08-266224251956121544141956-12-156224251962121444141962-12-146224251969091844161969-09-186224251975012144361975-01-216224251980110454271980-11-04196224251966081744251966-08-1762242519690126442X1969-01-2662242519

18、63050644211963-05-066224251965062544161965-06-256224251967022044321967-02-206224251964050744161964-05-076224251965020844561965-02-086224251963051844151963-05-186224251969122044141969-12-206224251960052344251960-05-236224251966101644371966-10-166224251963120844391963-12-086224251963102144471963-10-21

19、6224251965060444191965-06-046224251964042844111964-04-286224251965042444171965-04-246224251968111544461968-11-156224251966062244171966-06-226224251974052844261974-05-28198501198501TRUE1019850110198209198209TRUE2819820928196908196908TRUE2619690826198410198410TRUE1419841014198410198410TRUE211984102119

20、8311198311TRUE1819831118198603198603TRUE1919860319198410198410TRUE2119841021198709198709TRUE519870905198209198209TRUE619820906198607198607TRUE2319860723198804198804TRUE3019880430198410198410TRUE2119841021198509198509TRUE1519850915198602198602TRUE2019860220198409198409TRUE2319840923198407198407TRUE31

21、9840703198211198211TRUE1219821112198412198412TRUE1219841212198104198104TRUE1419810414198405198405TRUE1319840513198210198210TRUE1919821019198202198202TRUE2619820226197801197801TRUE2019780120198303198303TRUE1719830317198101197901FALSE1619790116196505196505TRUE219650502197812197812TRUE19197812191953111

22、95311TRUE2819531128195603195603TRUE2119560321197908197908TRUE3019790830195503195503TRUE119550301196412196412TRUE1619641216197412197412TRUE2819741228197902197902TRUE1819790218197802197802TRUE319780203197904197904TRUE2719790427195712195712TRUE319571203197708197708TRUE519770805198211198211TRUE111982111

23、1196904196904TRUE1519690415197902197902TRUE2419790224197904197904TRUE219790402195503195503TRUE1919550319198705198705TRUE919870509195509195509TRUE919550909198410198410TRUE1819841018198209198209TRUE1219820912197412197412TRUE2219741222198304198304TRUE1619830416198410198410TRUE1819841018197802197809FALS

24、E2719780927198512198512TRUE1819851218198110198110TRUE2819811028198008198004FALSE919800409198109198109TRUE1619810916198012198012TRUE1219801212198302198302TRUE719830207197109197109TRUE2119710921198305198305TRUE2619830526198311198311TRUE1919831119198007198002FALSE119800201198103198103TRUE23198103231956

25、05195605TRUE2119560521196008196008TRUE2219600822197708197708TRUE2219770822197906197906TRUE119790601197903197903TRUE1819790318196710196710TRUE3019671030195512195512TRUE2619551226195511195511TRUE719551107198601198601TRUE1019860110198706198706TRUE519870605197812197812TRUE1819781218197203197203TRUE15197

26、20315198204198204TRUE2519820425195510195510TRUE419551004198211198211TRUE219821102195311195311TRUE619531106198506198506TRUE2019850620198007198007TRUE2919800729195207195207TRUE619520706197906197906TRUE2519790625198510198510TRUE1419851014198410198410TRUE619841006196410196410TRUE2519641025196310196310TR

27、UE919631009195908195908TRUE2519590825198008198008TRUE2619800826195502195501FALSE2519550125195212195212TRUE3019521230198411198411TRUE3019841130197710197710TRUE1819771018195411195411TRUE1819541118196309196501FALSE2319650123198001198001TRUE1319800113198206198206TRUE2319820623196810196809FALSE2719680927

28、195305195305TRUE1519530515198206198206TRUE2419820624198010198010TRUE219801002197301197301TRUE119730101195601195601TRUE319560103195405195405TRUE1219540512197908197812FALSE2319781223197810197810TRUE2319781023197812197801FALSE219780102196411196408FALSE519640805195510195507FALSE1019550710196911196911TRU

29、E719691107198501198501TRUE1919850119198409198409TRUE2519840925197412197411FALSE1819741118196408196304FALSE819630408198401198401TRUE919840109195801195801TRUE2919580129195207195206FALSE619520606196501196501TRUE2019650120196306196306TRUE919630609198112198112TRUE1519811215196201196201TRUE719620107198507

30、198507TRUE2919850729197909197909TRUE119790901197608197608TRUE2819760828198110198110TRUE2019811020196202196202TRUE1519620215197410197310FALSE2319731023196606196606TRUE219660602195702195703FALSE719570307197906197906TRUE1019790610196403196403TRUE919640309195206195206TRUE719520607198002198002TRUE1198002

31、01196307196307TRUE1219630712195401195401TRUE1919540119196608196608TRUE219660802195208195208TRUE2619520826198110198110TRUE2619811026198302198302TRUE1919830219198610198610TRUE2819861028198511198511TRUE2819851128195801195801TRUE1519580115198012198012TRUE1819801218198101198101TRUE819810108198305198305TRUE119830501195607195607TRUE2219560722198009198209FALSE1819820918196409196409TRUE2819640928198204198204TRUE619820406196404196404TRUE619640406195808195808TRUE2319580823198512198512TRUE27198512