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

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

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
 
=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)
 
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)
 
Back
Top