2018年4月6日到2021年1月5日，月份差多少?
回答 (1)
2021-01-13 10:00 am
SQL DATEDIFF(MONTH,'2018/04/06','2021/01/05') 33
EXCEL =DATEDIF("2018/04/06","2021/01/05","M") 32
但是 =DATEDIF("2018/04/06","2021/01/06","M") 會是 33
大概是
=DATEDIF("2018/04/06","2021/01/05","M")+IF(DAY("2018/04/06")>DAY("2021/01/05"),1,0) 比較正確
EXCEL =DATEDIF("2018/04/06","2021/01/05","M") 32
但是 =DATEDIF("2018/04/06","2021/01/06","M") 會是 33
大概是
=DATEDIF("2018/04/06","2021/01/05","M")+IF(DAY("2018/04/06")>DAY("2021/01/05"),1,0) 比較正確
收錄日期: 2021-04-24 08:09:57
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20210112113055AA11x5Z