countif using dates

[rferley]

I have a spreadsheet that has dates in one column formatted as dd/mm/yyyy and I'm trying to count the number of jan, feb, etc. occurances in this spreadsheet. I've used the countif function as so: =COUNTIF(F2:F74;=>"2/1/2002")+COUNTIF(F2:F74;=<"2/28/2002") and get an error result for the formula. I've also tried the sumif function and can't seem to get the right configuration for the formula. Any ideas/concerns/further suggestions would be GREATLY appreciated?

 

[muchobrento]

Anybody have any idea how to use this same method, but account for different years? I tried using the array method that Mark W used, but realized that as soon as the year passes and January is being counted again that it will add up all of the January data from each year.