假定数据在A列,
C1:2001年11月1日
D1:2002年10月31日
B1填入公式
=COUNTIF(A:A,">"&C1)-COUNTIF(A:A,">"&D1)
即可
在最后一个单元格内=COUNTIF(A2:An,">=2001-11-1")-COUNTIF(A2:An,">2002-10-31")
或者另外一列的任意单元格=COUNTIF(A:A,">=2001-11-1")-COUNTIF(A:A,">2002-10-31")
即可,包含2001-11-1和2002-10-31这两个日期的统计数
=sumproduct((a2:a1000>=date(2001,11,1))*(a2:a1000>=date(2002,10,31)))
不好意思,刚才公式应该是
=sumproduct((a2:a1000>=date(2001,11,1))*(a2:a1000<=date(2002,10,31)))
=COUNTIF(A2:A83,">=2001/11/1")-COUNTIF(A2:A83,">=2002/11/1")
先排序,然后筛选