software

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,quot;gt;=quot;amp;date(2006,1,1))-countif(a2:a30,quot;gt;=quot;amp;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

quot;ferdequot; wrote:

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

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

quot;bpeltzerquot; wrote:

gt; =countif(a2:a30,quot;gt;=quot;amp;date(2006,1,1))-countif(a2:a30,quot;gt;=quot;amp;date(2006,2,1))
gt; That's counting the number of entries in or after January, then subtracting
gt; the number in or after February, leaving only January entries.
gt; --Bruce
gt;
gt; quot;ferdequot; wrote:
gt;
gt; gt; I have a single column a2:a30 that is formatted for dates. I would
gt; gt; appreciate any help in getting the right forumula to count the number of
gt; gt; January entries. Thank you very much in advance.
gt; gt; 04-Jan-06
gt; gt; 05-Jan-06
gt; gt; 12-Jan-06
gt; gt; 01-Feb-06
gt; gt; 04-Feb-06
gt; gt; 13-Mar-06
gt; gt; 15-Mar-06