Thread: Count dates falling in a certain range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Count dates falling in a certain range

If your dates are in column A this formula, say in cell C1, will give
you the number joining within the last 90 days

=COUNTIF(A:A,""&TODAY()-91)

then this formula for the next 90 days

=COUNTIF(A:A,""&TODAY()-181)-C1

then for the rest

=COUNTIF(A:A,"<"&TODAY()-180)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528784

Reply With QuoteReply With Quote