1、在excel中从日期里面提取出年月日需要分别用到函数DAY(serial_number),MONTH(serial_number),YEAR(serial_number)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/78310a55b319ebc42b12112a8c26cffc1e17161e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、其中,serial number 代表指定的日期或者引用的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e939013d4dea8d75ec54e736d19631?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、serial_number有多种输入方式:带引号的文本串、序列号,以及其他公式或函数的结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7ffbeaa5fdf00baa1cc112ac2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、从日期中提出日,输入函数:DAY(serial_number)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c20c9b809800f41bd5ac6e39cc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、从日期中提出月,输入函数:Month(serial_number)。excel中就可以根据输入的年月计算出累计月份了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/962bd40735fae6cdf83dccd201b30f2443a70ff3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)