Counting Date within date ranges

K

Komatsu

Count by Specific Date ('D1') to see how many times it is found between
all the Beginning dates ('A') and Ending Dates ('C') ranges. Then move
to next Specific Date ('D2'), inc.... See attachment.:confused:
 
B

Bernie Deitrick

Komatsu,

=SUMPRODUCT((A1:A10<=D1)*(C1:C10>=D1))

Copy down to get values for D2, etc. Change the 10 to match or exceed
your number of rows.

HTH,
Bernie
 
Top