Hello all,

I have looked through the archives and have seen several formulas that
should work in my spreadsheet, but return either a 0 or the wrong number.
The dates are entered using 1/6/08 and formatted to appear as Jan-08. I want
to count the number of cells that have Jan as a date, etc.

I have tried the following:
=COUNTIF(Data!F2:F65536,"=1/1/2008") -COUNTIF(Data!F2:F65536,"<=1/31/2008")
The result counts all cells rather than the 50 it should be

=SUM(COUNTIF(F2:F65536,{"12/31/08","<=1/1/09"})) the result is 0

=SUMPRODUCT((MONTH(Data!F2:F65536)=1),(YEAR(Data!F 2:F65536)=2008)) the
result is 0

I am stumped.

Would really appreciate the help!