Thread
:
COUNTIF criteria using date ranges?
View Single Post
#
3
Don Guillett
Posts: n/a
try
=sumproduct((rngaa1)*(rngA<b1))
--
Don Guillett
SalesAid Software
"Annie" wrote in message
oups.com...
How would I indicate that I want to count the number of dates fall
between Date A and Date B? I looked in the other message threads about
subtracting one COUNTIF from another, but I don't think it works for
dates.
Thank you,
Annie
Reply With Quote