I want to count the number of times a name appears in one column, if the date
in another column falls in a certain period. For instance: Count If A1:A5=B
OP and the date in B1:B5 is between 01/04/05 & 17/04/05.
ColA ColB
B OP 15/04/05
B LD 15/04/05
B OP 13/04/05
B OP 18/04/05
B PD 13/04/05 with the answer being 2!

The way the sheet is set up will not work in a pivot table (I don't think)
and i don't want to alter it. I've tried someproduct but can't get it to
work, i'm either writing it wrong or using the wrong formula. PLEASE HELP!!!!!

Thanks

Becks