Hi,

I am currently trying to use the AND operator as part of a countif
function and haven't been able to get it to work. I want to COUNT only
if a date is between 01/08/06 and 01/09/06, but can't work out how to.

My best attempt has been to use the AND operator to specify two
conditions (eg. is 01/08/06 and <01/09/06) but this hasn't worked.
Alternatively I have tried not using the AND operator at all and have
instead tried to create a 'between' function (eg. 01/08/0601/09/06)
but this also didn't work.

To help explain further, here is the function I wrote which doesn't
work (I'm aware that the "*" symbol is wrong, but don't know what to do
to get both of these conditions to hold):

=AND(COUNTIF('Resource
Summary'!$H$2:$H$108,"01/08/06"))*(COUNTIF('Resource
Summary'!$H$2:$H$108,"<01/09/06"))

Any ideas? If I haven't been clear then please ask and I'll attempt to
explain further.

Thanks,

Adam. :)


--
AdamPriest
------------------------------------------------------------------------
AdamPriest's Profile: http://www.excelforum.com/member.php...o&userid=37588
View this thread: http://www.excelforum.com/showthread...hreadid=572123