Thread: using AND/BETWEEN in a countif formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default using AND/BETWEEN in a countif formula
Hi,

Maybe you can use something like this if you have the dates in columb B
next to your days.

=SUMPRODUCT(--('Input Page'!A2:A50000,="Monday"),--('Input
Page'!B2:B50000TODAY()-6))

Regards,
Bondi

Reply With QuoteReply With Quote