how do I Count number of records beteen two dates- Excell 2007
 

need to count the number of records between two specific dates. Dates are in
column i2:i3000. Need to know how many record falls into period 1 1/4/08 to
28/4/08 inclusive; period 2 29/4/08 to 26/5/08 inclusive etc? Any advice

how do I Count number of records beteen two dates- Excell 2007
 

=COUNTIF(I2:I300,"=01-04-2008")-COUNTIF(I2:I300,"28-04-2008")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DK" wrote in message
...
need to count the number of records between two specific dates. Dates are
in
column i2:i3000. Need to know how many record falls into period 1 1/4/08
to
28/4/08 inclusive; period 2 29/4/08 to 26/5/08 inclusive etc? Any advice

how do I Count number of records beteen two dates- Excell 2007
 

In Excel 2007:

Using cells to hold the date periods.

K2 = start date = 4/1/2008 (m/d/y)
L2 = end date = 4/28/2008 (m/d/y)

=COUNTIFS(I2:I3000,"="&K2,I2:I3000,"<="&L2)

--
Biff
Microsoft Excel MVP


"DK" wrote in message
...
need to count the number of records between two specific dates. Dates are
in
column i2:i3000. Need to know how many record falls into period 1 1/4/08
to
28/4/08 inclusive; period 2 29/4/08 to 26/5/08 inclusive etc? Any advice