countif date

[Guest]

I have a single column a2:a30 that is formatted for dates. I would
appreciate any help in getting the right forumula to count the number of
January entries. Thank you very much in advance.
04-Jan-06
05-Jan-06
12-Jan-06
01-Feb-06
04-Feb-06
13-Mar-06
15-Mar-06

 

[Guest]

=countif(a2:a30,">="&date(2006,1,1))-countif(a2:a30,">="&date(2006,2,1))
That's counting the number of entries in or after January, then subtracting
the number in or after February, leaving only January entries.
--Bruce

 

[Guest]

AWESOME it works great. Thank you so much for your speedy reply