满足24小时内某一时间段的公式？请教！

Question

满足24小时内某一时间段的公式？请教！8:00:00至20:29:59等于LG线
20:30:00至7:59:59等于LF线？请同步回复1077439103 QQ号。非常感谢！

Answer 1

小于1937
=COUNTIF(A:A,">1973-1-1")

1937-1945
=COUNTIF(A:A,">=1937-1-1")-COUNTIF(A:A,">=1945-1-1")
或
=COUNTIFS(A:A,">=1937-1-1",A:A,"<1945-1-1") 2007及以上版公式

其余类同

2012以后
=COUNTIF(A:A,">=2012-1-1")