SR89

=SUMPRODUCT(--(A1:A20B1),--(A1:A20<B2))

I assumed that your dates are between A1:A20 and that the earlier date is in
B1 and the later date is in B2. Please adjust formula to fit your data.

Confirm with ctrl+shft+enter

Let me know if this works for you.

Dave

"SR89" wrote in message
...

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