Just check that the formula has the same range (twice) as your table
uses. If they are the same then check on your data - for some reason
there is a space before the final 7/18/2008 in your posting, so if you
have copied that directly from your file then perhaps that cell
contains a text value rather than a true date.

Hope this helps.

Pete

On Aug 19, 4:52*pm, JCS wrote:
Both suggestions are excellent but if I have a table that looks like the
following:
7/18/2008
7/18/2008
7/18/2008
7/18/2008
7/18/2008
7/18/2008
7/18/2008
7/18/2008
*7/18/2008 * *
7/3/2008

Both fiormulas yield 8 instead of nine. *Any suggestions?

Thank you,
John



"JCS" wrote:
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- Hide quoted text -

- Show quoted text -