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

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
 
B

Bob Phillips

=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)
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to count the total Number of dates between two dates How? 3
To Calculate the qty b/w two dates 6
How do I Exclude a list of dates in a date calculation? 2
count the number of months between two dates 3
Excel - count the number of records between two specific dates. 4
how do i use averageifs function? 2
Picking out a Period, in relation to certain cells 6
Functions 1

Top