Thread: tally a range of dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maistrye Maistrye is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote