IF Date falls within a Month - Help!

[maxhayden]

Hi there,

I want to run an IF loop that checks if cells in Culumn A fall within a certain month. If they do, then it will count.

Is there a way of doing this. Eg. If Cells(i, 1) = Month(September) Then .....

[nst1107]

The way you've got it constructed right now, just dim another variable to count the cells, and finish the If statement something like this:If Month(Cells(i,1) = 9 Then x = x + 1

[Bob Phillips]

Use a formula

=SUMPRODUCT(--(MONTH(A2:A20)=9))