Try this:

=SUMPRODUCT((MONTH(M2:M999)=9)*(YEAR(M2:M999)=2008 ))

Hope this helps.

Pete

On Oct 2, 12:20*pm, Exceluser1
wrote:
My formula is COUNTIF(M2:M999,"01/09/08,30/09/08")

I want it to count if the date in the cell is in any given month - the above
isn't working.

Can anyone suggest another way to add a date range as the criteria?