Count number of dates between a specified period of time

S

Sodak

I have a column in a spreadsheet that contains the dates that inspections
occurred on. From that I want to generate a count of the number of
inspections that occurred between certain dates. Example:

Column A
2/3/09
3/4/09
3/6/09
3/6/09
5/6/09
6/5/09
7/6/09

How can I write a formula that will count the number of dates that are
between 3/1/09 and 6/30/09? I assume it would use the COUNTIF function.

Thanks.
 
M

Mike H

Hi

=SUMPRODUCT((A1:A15>=DATE(2009,3,1))*(A1:A15<=DATE(2009,6,30)))

In practice I would use cell references in the formula to prevent having to
edit it

=SUMPRODUCT((A1:A15>=C1)*(A1:A15<=D1))
 

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

counting 8
Counting Dates 1
Count unique dates within each unique ID 6
Number of days in a specific month between various start and end d 8
How many months between two date range 10
Counting latest date in two columns 7
Countif or Sumif with frequency 4
Count the number of dates less than a given date 1

Top