出生日期
2002-06-18
2002-08-08
2002-05-13
2002-02-02
2002-07-08
2003-02-27
2003-05-25
2003-04-25
2003-04-26
2002-12-20
2002-07-04
2003-08-21
2002-08-19
2002-10-05
2002-10-29
2003-01-15
2002-08-02
2002-07-10
2002-08-11
2002-02-14
2002-02-14
2002-02-02
2002-08-14
2002-10-12
2002-07-09
2002-01-28
2002-04-18
2002-12-31
2003-04-13
2002-03-24
2003-03-31
2003-08-03
2003-08-16
2003-08-08
2002-07-04
2002-09-25
2002-07-05
2002-12-04
2002-04-04
2002-08-10
2003-02-17
2002-03-11
2002-02-15
2002-07-26
2002-12-08
2003-05-25
2002-03-01
2002-04-06
2009-09-18
2002-07-02
2003-05-14
2002-02-27
2002-04-30
2002-06-28
2002-09-08
2002-03-28
2002-04-21
2002-09-15
2003-02-20
2002-05-09
2002-03-12
2003-02-09
2002-02-14
2002-08-08
2002-04-26
2002-04-12
2002-02-10
2003-06-13
2006-04-05
2002-11-24
2002-07-12
2002-10-13
2003-03-29
2003-02-06
2002-01-19
2002-05-13
2002-12-26
2003-02-14
2002-12-24
2002-11-06
2003-05-31
2002-06-24
C1:2001年11月1日
D1:2002年10月31日
B1填入公式
=COUNTIF(A:A,">"&C1)-COUNTIF(A:A,">"&D1)
即可
或者另外一列的任意单元格=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)))