Thread: Counting dates in a RANGE (yargh!) :)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Davis
 
Posts: n/a
Default Counting dates in a RANGE (yargh!) :)
Step three (counting dates between ranges) works by using:

=SUMPRODUCT(--(FM!J$3:J$5403$E$1),--(FM!J$3:J$5403<=$G$1))

.... where E1 and G1 are the date "limits", respectively :)

Quite happy to have this finished! Hopefully this can help someone in
the future.

Reply With QuoteReply With Quote