Thread: count number of dates falling in the next seven days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default count number of dates falling in the next seven days
B1=TODAY()
B2=TODAY()+7

=SUMPRODUCT(($A$1:$A$100B1)*($A$1:$A$100=<B2))

=COUNTIF($A$1:$A$100,"=<"&B2)-COUNTIF($A$1:$A$100,""&B1)

adjust your ranges to suit


On 29 Kwi, 11:58, Louisa wrote:
I have a worksheet with a list of arrival dates. I need to count how many of
these dates fall within the next seven days. This calculation would need to
be self-updating on a daily basis. Is this possible?

Reply With QuoteReply With Quote