Try this:

=SUMPRODUCT(--(TEXT(A1:A100,"mmm yyyy")="Jan 2006"))

--
Biff
Microsoft Excel MVP


"Mark Solesbury" <marksolesbury@asearchenginethatnowdoeseverythingm ail.com
wrote in message ...
I have a column with lots of dates in.

I want a formula to count the number of dates, ie jan 2006 = 12

Any ideas,
Ive tried CountIf, and 2006 but i think the date formatting is messing
with it.


--
Mark

http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox