tally a range of dates

[Sher]

I have a range of dates on a worksheet that I want to tally for each month.
I have used =COUNTIF(C8:C78,"4/1/06") (this works only for 4/1/06), but my
date range is from 4/1/06-4/30/06, Any ideas

[Maistrye]

I have a range of dates on a worksheet that I want to tally for each month.
I have used =COUNTIF(C8:C78,"4/1/06") (this works only for 4/1/06), but my
date range is from 4/1/06-4/30/06, Any ideas

Perhaps = COUNTIF(C8:C78,"<5/1/06") - COUNTIF(C8:C78,"<4/1/06")

HTH,
Scott

[Toppers]

=SUMPRODUCT(--(MONTH(C8:C78)=4))

"Maistrye" wrote:

>
> Sher Wrote:
> > I have a range of dates on a worksheet that I want to tally for each
> > month.
> > I have used =COUNTIF(C8:C78,"4/1/06") (this works only for 4/1/06), but
> > my
> > date range is from 4/1/06-4/30/06, Any ideas
>
> Perhaps = COUNTIF(C8:C78,"<5/1/06") - COUNTIF(C8:C78,"<4/1/06")
>
> HTH,
> Scott
>
>
> --
> Maistrye
> ------------------------------------------------------------------------
> Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
> View this thread: http://www.excelforum.com/showthread...hreadid=563410
>
>