Colume A-
06/09/2009
07/09/2009
08/09/2009
09/09/2009
10/09/2009
11/09/2009
12/09/2009
今日係09/09/2009, 想令函數以後會每日自動計算 總日數:
Answer 1: A1至A7中 小於今日的 總日數 (3日)
Answer 2: A1至A7中 大於或等於今日 的總日數 (4日)
試過:
=countif(A1:A7,"<today()") 顯示為0
=countif(A1:A7,"<DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())") 仍顯示為0
但
=countif(A1:A7,"<09/09/2009") 就有答案3
該如何SET? 請指教!
Excel 大於或小於 今日 的總 日數
2009-09-09 7:37 pm
回答 (1)
2009-09-09 7:51 pm
✔ 最佳答案
=countif(A1:A7,"<"&today())如 B1 是 =TODAY()
=countif(A1:A7,"<"&B1)
收錄日期: 2021-04-23 23:28:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090909000051KK00385