✔ 最佳答案
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.
