下图有一组日期,分别加上3日、3月、3年。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d9a6a367b3b6d55fbb3fbd957?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
1、A1日期加三天。在C1中输入“=a1+3”即可。
2、A2日期加3月,可在C2中输入“=edate(a2,"3")”即可。
3、A3日期加3年,可在C3中输入“=edate(a3,"3"*12)”即可。![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca806538feece1b691dda144ad348215?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、如果B4~B7是数字,要求A列日期加B4~B7的月数。那就在C4单元格输入“=edate(a4,b4)”算出C4的值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a63f6246b600c3354099b6d1c4c510fd9f9a127?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后,把C4的公式拖拽到B7即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faedab64034f78f07721df567f310a55b3191c68?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
注意:如果显示“#NAME”。工具-加载宏,勾上“分析工具库”。这是EXCEL自带的加载宏,默认是选上的。