从身份证号码中提取出生年月日的方法如下:
工具:联想笔记本电脑E41-55、Windows XP、Office2021办公软件。
1、打开excel表格,在A列中输入身份证号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a7867d5786546a09c93d70cf506f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在B列中输入MID函数,格式为:=MID(A2,7,4)&"年"&MID(A2,11,2)&"月"&MID(A2,13,2)&"日"。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f06a6ea3c5a90f4bfbfbed0413?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、将光标定位在公式末尾,按下回车,出生年月日就已经从身份证号码中截取出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1c950a7b02087bf417bf9bb3ffd3572c11dfcf1d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选中B2表格,将鼠标放在B2表格右下角。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93dc897c2ad923df8dcd1005407?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、当光标变成一个黑色的十字时,按住鼠标向下拉,所有的出生年月日就都被提取出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca8004a1f5bd9c2397dda04483c0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)