countif date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
=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
 
Back
Top