Hi All,
I'm trying to find the number of dates that fall between 7/18/08 and 7/25/08
in the follwoing table. I'm using sumproduct with very little luck. I've
tried the following formulas:

SUMPRODUCT((A1:A10=7/18/2008)+(A1:A10=7/25/2008)) yields 10 and
SUMPRODUCT((A1:A10=7/18/2008)*(A1:A10=7/25/2008)) yields 0

What I'm looking for is 7. Maybe I'm using the wrong formula. Any help
would be greatly appreciated.

7/18/2008
7/19/2008
7/20/2008
7/26/2008
7/24/2008
7/27/2008
7/25/2008
7/18/2008
7/18/2008
7/3/2008

Thanx,
John