One way:

=COUNTIF(Log!H:H,"2/8/08")-COUNTIF(Log!H:H,"=2/16/08")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tromba" wrote in message
...
My daughter is trying to count dates within a certain range, and I figured
it
out quickly with COUNTIFS:

=COUNTIFS(Log!H:H,"2/8/08",Log!H:H,"<2/16/08")
result was 34

Then I found out she only has Office 2003 at her office. I've tried all
kinds of solutions and suggestions but haven't had success. I think it
might
be because I'm using dates and most examples I've seen are using strings
or
numbers.

I know SUMPRODUCT can't use whole rows, and tried this

=SUMPRODUCT(--(Log!H1:H4874"2/8/2008"),--(Log!H1:H4874<"2/16/2008")
result was 0 so it didn't work

Any suggestions?