tally a range of dates
 

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

tally a range of dates
 

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

tally a range of dates
 

=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