Hi

try

=sumproduct(--($E$6:$E$83=$I$5)*($E$6:$E$83<=$I$6))

assuming that the range are on E6:e83 and I5 01/01/2003 and I6 01/01/2004

hth
regards from Brazil
Marcelo

"SR89" escreveu:


Hi,

I can't figure out how to count how many occurances fall between two
dates. For example, how many of the dates in a column are Jan 01,
2003 and < Jan 01, 2004.

COUNTIF will count one occurance only, so I think that I have to use
maybe SUMPRODUCT but am now sure how the formula would work.

Any ideas?

Thanks,


--
SR89