Counting a range of cells with dates within a certain range

[MSE]

I am trying to count a range of cells with a value between a certain date. In this sheet, I document visits to particular properties with the date, and I want to count a monthly total of visits at the bottom.

I want to count all the cells in the within the sheet that contain a date in January, February, March, etc. but not count the start and end dates.

BTW, This forum is an incredible resource, which I've used a number of times. Thanks for all who contribute.

[bebo021999]

In D12:

=COUNTIFS($D$2:$O$9,"<="&EOMONTH("2016/12/31",COLUMNS($A:A)),$D$2:$O$9,">0")-SUM($C12:C12)

Drag accross

[Pete_UK]

I'm not sure what you mean by:

... but not count the start and end dates ...

but you need to format cell D12 in your example file as General to get it to display 19 - is that the answer that you expect from your data?

Hope this helps.

Pete

[davesexcel]

if you have the first day of the month in D11:O11 then format that cell to just display months.
Use this formula for D12 and drag it across.

=COUNTIFS($D$2:$O$9,">"&D11,$D$2:$O$9,"<"&EOMONTH(D11,0))

[bebo021999]

After checking again, try again:

=COUNTIFS($D$2:$O$9,"<"&EOMONTH("2016/12/31",COLUMNS($A:A)),$D$2:$O$9,">"&EOMONTH("2016/12/31",COLUMNS($A:A)-1)+1)

[MSE]

Thanks guys. The formula from bebo 021999 and davesexcel both work on my sample, but unfortunately I cannot figure out which
cells to adjust in my actual spreadsheet. Here is the actual one I'm using with the location info taken out. I DO want to count
dates in both "open" and "closed" sections


DaveUK, I meant that I didn't want to count the Start and End date columns.

[MSE]

Lost the attachment.

[MSE]

I was able to get davesexcel's formula to work. Thanks again!