countif date

[ferde]

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

[bpeltzer]

=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

[ferde]

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