# Count cells with a specific time stamp

#### Randomhero180

##### New Member
Hey All

here is the formula I am currently using:

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))

This counts all entries with the status "Contact Sheet Available/Disc Sent" and that have a timestamp within the current month.

I need to alter this to count the last week in september and the first 3 weeks in october (using this month as an example and will have to have to be able to run without changing dates next month)

Any ideas?

RH

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
The question seems choatic. Don't you mean,

"How do count all rows within a 4-week period based on a starting date I can indicate?"

Trust me I know it sounds chaotic haha.

How about a way that I can input two dates in the formula ie: 9/26/11 and 10/21/11

and count the number of cells that have the status "Contact Sheet Available/Disc Sent"

Again this is what I have now

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))

Trust me I know it sounds chaotic haha.

How about a way that I can input two dates in the formula ie: 9/26/11 and 10/21/11

and count the number of cells that have the status "Contact Sheet Available/Disc Sent"

Again this is what I have now

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(MONTH(Sheet1!H19:H15235)=MONTH(TODAY())))
Use cells to hold the date criteria:
• A1 = 9/26/2011
• B1 = 10/21/2011
Then:

=SUMPRODUCT((Sheet1!B19:E15235="Contact Sheet Available/Disc Sent")*(Sheet1!H19:H15235>=A1)*(Sheet1!H19:H15235<=B1))

Replies
4
Views
238
Replies
1
Views
382
Replies
4
Views
435
Replies
3
Views
1K
Replies
0
Views
452

1,203,223
Messages
6,054,228
Members
444,711
Latest member
Stupid Idiot

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