# Using Date Range to Count additional colums

#### tlceph415

##### New Member
Hello all, New to the board I am glad I found you all . There is a lot of data here that I will be using often.

I am setting up a report to look at data from on tab that calculates range and criteria from another tab.

I need a formula that will look at my Date Column and if the date falls between the 1st and the 30th or 31st of the month I need it to count numbers in another column.

Number of People in Household Date of First Visit
7 10/12/2005
5 10/12/2005
5 10/12/2005
5 10/12/2005
6 10/12/2005
2 10/12/2005

Any help is appreciated.

Thank You!

TLCEph415

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
it is not clear what is meant by quote
1st and the 30th or 31st of the month unquote
any dte wil be between 1 and end date

besidses the dates are all the same. eithe index-match or vlookup will find out any one of these same dates mostly the first one.

how are the dates entered 10/12/05 does it mean october 12th?????

it is not clear what is meant by quote
1st and the 30th or 31st of the month unquote
any dte wil be between 1 and end date

Thank you for the responce

Here is what I came up with from viewing other simular questions on the board to get my needs met, but as you can see I have to use 2 different formula's to identify the date that I want to find out of the month query I then sum the 2 results to identify how many times each date occured.

=SUMPRODUCT(('Customer Sign-In Data'!D7:D4999=38637)*(A3=A4)*'Customer Sign-In Data'!C7:C4999)

=SUMPRODUCT(('Customer Sign-In Data'!D7:D38=38650)*(A3=A4)*'Customer Sign-In Data'!C7:C38)

My goal is to develop a report that will use the data on a mo to mo basis to identify how many people where served during that mo.

besidses the dates are all the same. eithe index-match or vlookup will find out any one of these same dates mostly the first one.

# People Date of First Visit
7 10/12/2005
5 10/12/2005
5 10/12/2005
5 10/12/2005
4 10/25/2005
3 10/25/2005
3 10/25/2005
5 10/25/2005

how are the dates entered 10/12/05 does it mean october 12th?????

Yes

Thanks again sorry for the lack of correct info.

Replies
3
Views
184
Replies
2
Views
162
Replies
3
Views
98
Replies
3
Views
135
Replies
2
Views
200

1,207,387
Messages
6,078,197
Members
446,320
Latest member
vatra

### 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