I am trying to use the with a date and a range of cells with a count range.

=IF(f7:f117/31/08,COUNT(b7:b11),"") I am getting a value error. What I am
wanting my end result to show is if the dates within f7 to f11 are < 7/31/08
count how many invoices I have with an August date that are in the range of
B7:B11.

Should I use a between function?

Any help would be appreciated.