Thread: count number of dates falling in the next seven days
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default count number of dates falling in the next seven days
Hello Louisa,

Then I suggest to use SUMPRODUCT:

=SUMPRODUCT(--(A1:A999<TODAY()+8),--(A1:A999TODAY()),--(B1:B999="M"))

resp.

=SUMPRODUCT(--(A1:A999<TODAY()+8),--(A1:A999TODAY()),--(B1:B999="F"))

Regards,
Bernd
Reply With QuoteReply With Quote