我想問excel要用咩function/formula可以計算出以下2個日期相差多少日?
1/1/2007 & 1/2/2007
= 32 days
Excel 問題 (快!)
2007-10-04 6:46 pm
回答 (4)
2007-10-04 7:14 pm
✔ 最佳答案
首先打左1/1/2007 and 1/2/2007在不同的格仔.按 funtion , choose 日期及時間, choose DAYS360, start date choose 1/1/2007( 格仔), end date choose 1/2/2007 ( 格仔), 答案係３０． 相距日子係３０， 再加返１／１ 及 １／２ 個日， ｔｏｔａｌ ３２．
參考: 自己
2007-10-04 8:15 pm
=date(2007,2,1)-date(2007,1,1)+1 & "days"
2007-10-04 7:01 pm
=DATE(2007,2,1)-DATE(2007,1,1)
type the above formula in excel...
actually it only calculates 31 days...if you wanna includes open and end date, add "+1" at the end...
2007-10-04 11:02:41 補充：
If you wanna includes open and end date, add 1 at the end...
type the above formula in excel...
actually it only calculates 31 days...if you wanna includes open and end date, add "+1" at the end...
2007-10-04 11:02:41 補充：
If you wanna includes open and end date, add 1 at the end...
參考: me
2007-10-04 6:50 pm
31 days
收錄日期: 2021-04-23 13:35:43
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071004000051KK00820