try
=sumproduct((rnga>a1)*(rngA<b1))

--
Don Guillett
SalesAid Software
donaldb@281.com
"Annie" <ashapren@yahoo.com> wrote in message
news:1125078145.279053.146190@z14g2000cwz.googlegroups.com...
> How would I indicate that I want to count the number of dates fall
> between Date A and Date B? I looked in the other message threads about
> subtracting one COUNTIF from another, but I don't think it works for
> dates.
>
> Thank you,
> Annie
>