Counting Date within date ranges

  • Thread starter Thread starter Komatsu
  • Start date Start date
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:
 
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
 
Back
Top