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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting the occurrence of specific text within a date range 4
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Summing Results Based On A Specific Date 2
VBA Coding Help for Beginner 0
Counting multiple occcurrences between date range 3
Lookup whole sheet and add datas from specified date to end date 0
identify which years are contained within a range of dates 2
Need to Count the number of times a value occurs within a dt range 9

Top