Count occurrence of individual date within dates in range

[mhessnm]

I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22.

In the range of start dates and end dates in my census data, I want to count the number of instances that each individual date in my Day of Month data falls within the Start Date and End Date in my census data.

I'm sorry I had to attach an image as I can't get XL2BB to install as a tab in my Excel.

I have racked my brain on this. I haven't made COUNTIFS with OR logic work, and I've tried SUMPRODUCT. In the image I've provided you the count of 7/1/22 should be 19 (Row 89 through Row 107), 7/2/22 should be 19, 7/3/22 should be 15....

I know it's probably something simple that I'm missing. Any enlightenment appreciated.

 

[Joe4]

Try putting this in cells G91 (assuming F91 has the 7/1/2022 date in it):

=COUNTIFS(A:A,"<=" & F91,B:B,">=" & F91)

and copy down for all rows.

 

[mhessnm]

I have a set of data in which two columns define a start date and end date - I'll call it my Census data. I have another dataset, call it my Day of Month data with one column that has individual dates of a month, i.e. 7/1/22, 7/2/22....7/31/22.

In the range of start dates and end dates in my census data, I want to count the number of instances that each individual date in my Day of Month data falls within the Start Date and End Date in my census data.

I'm sorry I had to attach an image as I can't get XL2BB to install as a tab in my Excel.

I have racked my brain on this. I haven't made COUNTIFS with OR logic work, and I've tried SUMPRODUCT. In the image I've provided you the count of 7/1/22 should be 19 (Row 89 through Row 107), 7/2/22 should be 19, 7/3/22 should be 15....

I know it's probably something simple that I'm missing. Any enlightenment appreciated.

 

[mhessnm]

Thank you! That was the problem. It's been a long week...I needed to exchange the operators to the other side and I just couldn't see my way through the haze.

 

[Joe4]

You are welcome.
Glad I was able to help!