Counting Dates between Two Dates

[stans]

I have a date in C1 and D1 such as 1/1/2010 and 1/7/2010 which is a 7 day period.
Then down the sheet for each 7 day period throughout the year.

In a list of inspections, each inspection date is entered in column E

In another column down the page I would like to count how many inspection dates fall between and including the two dates in column C and D

[stans]

An example with the count in G column.

I should have lowed the data and stated below Row 1, which I can adjust later.

[HansV]

Let's say you insert headers in row 1.
In G2, enter the formula

=SUMPRODUCT(($E$2:$E$6>=C2)*($E$2:$E$6<=D2))

(adjusting $E$2:$E$6 to the full list of inspection dates)

Fill down as far as needed.

Alternatively, since you're using Excel 2007 or later:

=COUNTIFS($E$2:$E$6,">="&C2,$E$2:$E$6,"<="&D2)

See the attached version.

EL Question Dates.xlsx

[stans]

Exactly what I needed, thanks again!