# Count values between two dates (show sum per day)

#### Llupo01

##### Active Member
Hello guys,

I would like to ask you for bit of help...I have table like the one below and What I would like to do is to have in next column all days in year and show how many occurences are at that day...source table is the one below where I have ,,From" critera, "To" which are dates between are those occurences, then "Freq" criteria (that shows which days in week between those dates it occurs) followed by columns, which are showing how many mondays, tuesdays etc is there between dates, which shows me sum of events..And I would like to have it also per day...If anyone have some idea, thank you very much in advance for any kind of help.

 Monday ​ Tuesday​ Wednesday​ Thursday​ Friday​ Saturday​ Sunday ​ From ​ To​ Freq ​ 1 ​ 2 ​ 3​ 4​ 5​ 6​ 7 ​ 01-Jun-19​ 15-Jun-19​ 1 4 6 2​ 0​ 0​ 2​ 0​ 3​ 0​ 16-Jun-19​ 01-Sep-19​ 1234567 11​ 11​ 11​ 11​ 11​ 11​ 12​ 31-May-19​ 14-Jun-19​ 3 5 7 0​ 0​ 2​ 0​ 3​ 0​ 2​ 15-Jun-19​ 31-Aug-19​ 1234567 11​ 11​ 11​ 11​ 11​ 12​ 11​ 31-Mar-19​ 07-Apr-19​ 2 4567 0​ 1​ 0​ 1​ 1​ 1​ 2​

<tbody>
</tbody>

Brgds,
Tomas

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
I, for one, don't understand this.
Can you supply some expected output ?

For example first row: Between 1st June and 15th june the freqency says 146, this mean Monday, Thursday, Saturday. Between 1JUN19 and 15JUN19 is 2x monday, 2 xthursday, 3x saturday. Expected or desired output is 1JUN19 - 1 (saturday), 2JUN 0 (sunday and freq says nothing in day 7), 3JUN (monday) = 1 etc till 15 JUN.

Replies
1
Views
68
Replies
1
Views
222
Replies
2
Views
100
Replies
7
Views
84
Replies
6
Views
232

### Forum statistics

1,203,491
Messages
6,055,727
Members
444,814
Latest member
AutomateDifficulty

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back