count records in a date range
You can use SUMPRODUCT
=SUMPRODUCT((A1:A100=B1)*(A1:A100<=B2))
A1:A100 ....date range
B1 start date
B2 end date
HTH
JG
"jiml" wrote:
I have a worksheet in which I am trying to count the number of records in a
date range. For example, the Submit_Date column contains the following
dates/times (cells a1:a5):
12/17/2005 12:00:54 PM
12/16/2005 1:00:54 PM
12/17/2005 9:00:13 PM
12/10/2005 7:54:16 AM
12/17/2005 10:04:11 AM
I would like to count the number of records with a Submit_Date between
12/1/2005 12:00:00 PM and 12/31/2005 11:59:59 PM.
Any suggestions?
--
Jim
--
Jim
|