用身份证号码求出出生时间.doc

出生年月：=mid(J5,7,4)&-&mid(J5,11,2)&-&mid(J5,13,2)年龄：=if(month(now()-mid(J5,11,2)0,year(now()-mid(J5,7,4)-1,year(now()-mid(J5,7,4)2000-03-202000-09-102000-12-122000-02-081993-02-182000-10-161999-10-152000-03-242000-08-032000-08-302000-03-102000-12-142000-02-172000-09-052000-03-222000-10-162000-07-182000-08-162001-03-15-2001-04-252000-04-102001-12-272001-04-102001-03-172000-08-232000-12-032000-01-072000-04-10-2000-09-201999-10-272000-12-282001-02-032000-04-212001-07-102000-01-052000-04-232000-02-062001-04-041999-12-192000-02-122000-05-141999-10-212000-07-112000-02-022000-10-112000-12-081999-09-252000-08-11-2000-01-292000-05-101999-07-181999-04-221998-09-241998-11-151999-12-172000-02-151998-06-082000-09-111999-02-011999-05-212000-04-101998-09-252000-01-222000-02-192000-11-202000-08-022001-08-171999-10-062001-07-172000-06-152001-08-171999-07-261997-03-062000-07-172000-10-212000-08-152000-08-25-1999-08-08