问题已解决
請(qǐng)問(wèn)如何計(jì)算兩個(gè)日期之間月差數(shù),網(wǎng)上給的函數(shù)復(fù)制上去出不來(lái)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
你好,一般用datedif函數(shù),你網(wǎng)上搜索的函數(shù)是哪個(gè),方便截圖的話把你的截圖上傳
2019 08/07 09:51
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84784971 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 08/07 09:53
還有一個(gè)光用datedif的公式,我都試了,不行
FAILED
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
王銀花老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/07 10:06
直接用DATEDIF函數(shù),三個(gè)參數(shù),第一個(gè)是開(kāi)始日期,第二個(gè)結(jié)束日期,你計(jì)算的是月份差值,最后一個(gè)參數(shù)是Y
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
王銀花老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/07 10:07
錯(cuò)了Y是年,M代表月
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
王銀花老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/07 10:08
比如D2單元格輸入:=datedif(C2,B2,“M”)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84784971 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 08/07 10:23
用了函數(shù),反饋是錯(cuò)誤
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84784971 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 08/07 10:23
就是你說(shuō)的那個(gè)m
![](https://pic1.acc5.cn/009/16/86/91_avatar_middle.jpg?t=1651203222)
王銀花老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 08/07 10:33
你截圖你用的公式,具體錯(cuò)誤是哪塊錯(cuò)誤
![](/wenda/img/newWd/sysp_btn_eye.png)