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?