Compound condition with COUNTIF

I want to be able to count values between 2 dates in a table. The query will
look something like:

=COUNTIF('Roll Out Schedule
23-Nov-05'!$H$3:$H$953,AND(">27/11/05","<05/12/05"))

Can anyone tell me where I'm going wrong?

=COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,">27/11/05-
COUNTIF('Roll Out Schedule 23-Nov-05'!$H$3:$H$953,">05/12/05")



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike McLellan" <MikeMcLellan@discussions.microsoft.com> wrote in message
news:FED7E386-BEC8-426E-9085-894A6CD494BE@microsoft.com...
> I want to be able to count values between 2 dates in a table. The query
will
> look something like:
>
> =COUNTIF('Roll Out Schedule
> 23-Nov-05'!$H$3:$H$953,AND(">27/11/05","<05/12/05"))
>
> Can anyone tell me where I'm going wrong?