countif date
 

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 date
 

=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

"ferde" wrote:

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 date
 

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

"bpeltzer" wrote:

=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

"ferde" wrote:

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