# Count cells with Dates

#### helpprod

##### New Member
i have dates in each cell eg
12/12/01 D1
12/12/01 D2
12/12/01 D3
11/12/01 D4
11/12/01 D4
11/12/01 D4
is there a way to count how many cells have the date 12/12/01 i have a whole month of dates and i need to see what days have the most sales

Thanks
Ryan

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
On 2002-10-14 23:34, helpprod wrote:

i have dates in each cell eg
12/12/01 D1
12/12/01 D2
12/12/01 D3
11/12/01 D4
11/12/01 D4
11/12/01 D4
is there a way to count how many cells have the date 12/12/01 i have a whole month of dates and i need to see what days have the most sales

Thanks
Ryan

have you considered using a pivot table for this?

never used on before!!

try it (data | pivot table) - you'll be impressed!

Have you considered using

=mode(A1:A19)

where A1:A19 represents the range that contains your sales dates. Remember to format the cell as date or you will just get the number that equals the date.

Any help?

OK what i have is 6 pages with
upto 50 cells on each page eg A1 - A50

A1-A5 has 12/10/02
A6-A10 has 13/10/02
A11-A17 has 14/10/02
A18-A24 has 15/10/02
A25-A50 has 16/10/02

i need a cell that if i type in 12/10/02 another cell tells me there was five sales that day etc.
i dont know where to start or if i can do this so any help would be great!!!!

Ryan

=SUM(COUNTIF(Sheet1!A1:A50,D1), COUNTIF(Sheet2!A1:A50,D1), COUNTIF(Sheet3!A1:A50,D1), COUNTIF(Sheet4!A1:A50,D1), COUNTIF(Sheet5!A1:A50, D1), COUNTIF(Sheet6!A1:A50, D1))

where D1 is the cell that contains the date you want to find. This may be messy, but it will do the job. Remember to change the sheet names to correspond to yours
This message was edited by The Idea Dude on 2002-10-15 00:59

That worked

Thank you

Ryan

Replies
4
Views
241
Replies
6
Views
136
Replies
4
Views
250
Replies
4
Views
168
Replies
6
Views
342

1,206,971
Messages
6,075,925
Members
446,170
Latest member
zzzz02

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