count with two conditions

Hi,

The requirement is: i have a list of date values in column A to C with header say, grade A, B and C respectively. I need to count if :
1. dates are within a range say, jan 01 08 to jan 31 08
2. column header is, in this case, "Grade A"

I hope I am clear.

thanks in advance

Hi It worked ! thanks! in case if I require one more condition;

for ex. i have grade A to Grade E from A1 to E1 and some dates from A2 to E2. From the specified range of dates, it should count only if the header is Grade B or C, ignoring Grade A, D and E. I tried with this formula and seems not working... sure that I am very near..

=SUMPRODUCT((A2:E2>J2)*(A2:E2<J3)*(A1:E1 ="Grade B")*(A1:E1 ="Grade C")

where J2 and J3 are the start date and end date respectively.

Can anybody help...Thanks.