excel日期加减计算方法如下:
工具:联想小新潮7000-13、Win 10、Microsoft Office2016。
1、打开Excel软件,在单元格中输入需要计算的日期,输入的日期格式为:年/月/日。
![](https://iknow-pic.cdn.bcebos.com/4a36acaf2edda3ccb02517b413e93901203f9265?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在空白的单元格上输入等于符号,用鼠标点击最终日期,输入减号符号,用鼠标点击最初的日期。
![](https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1fad2239c89504fc2d4626965?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、输入完成后,点击回车,可显示出两个日期之间相差的天数。
![](https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7ef2ee707b2effaaf51f2de6665?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在空白的单元格上输入等于符号,用鼠标点击开始日期,输入加号符号,用鼠标点击最终的日期。
![](https://iknow-pic.cdn.bcebos.com/fcfaaf51f3deb48f6aa80e4ae21f3a292cf57865?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、输入完成后,点击回车,可显示出两个日期之间总的天数。
![](https://iknow-pic.cdn.bcebos.com/9825bc315c6034a8ae231715d913495408237665?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)