急急急 !!! 想問關於excel函數的問題

Easy!

You can subtract the 2 dates, and you can get the no. of days between the dates. But remember to set the format of the cell to 'General Number', otherwise the cell format will be set in default to date format.

If you want to find the no. of weeks, you can divide the no. of days between the dates by 7, and truncate the number.

For example,
Cell A1 = 2007年4月23日
Cell A2 = 2007年6月26日
Cell A3 = TRUNC((A2-A1)/7)

You will have the result of 9, the logic is as follows,
A2 - A1 = 64 days, which is 9 weeks and 1 day (63 + 1)
(A2 - A1)/7, you will have 9.14
After trauncation, you will get the result 9, which is the no. of weeks between the dates.

See if it can help.

2007/7/1 to 2007/7/14 是 13日 (不足兩星期), 答案當然等於1了
幾多個WEEK & 幾多日.....
設日期在 E8 及E9
=INT((E9-E8)/7)&" . " &(E9-E8)-INT((E9-E8)/7)*7
(注意: 公式中並沒有空格)

2007-08-31 23:29:00 補充：
設日期在 E8 及E9=INT((E9-E8)/7)& " . " &WEEKDAY(E9-E8)(注意: 公式中並沒有空格)