Count number of dates between a specified period of time

[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.

 

[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))

 

[Gary''s Student]

=SUMPRODUCT((A1:A7>=DATEVALUE("3/1/2009"))*(A1:A7<DATEVALUE("7/1/2009")))