count records in a date range
Jim,
Try this
=SUMPRODUCT(--(A1:A5=--"2005-12-01 12:00:00 PM"),--(A1:A5<=--"2005-12-31
11:59:59 PM"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"jiml" wrote in message
...
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
|