Countif formula for dates

[JimmyG.]

I have a list of dates formatted dd/mm/yy hh:mm I want to be able to count the number of entries for specific dates however I get an error when using countif. Is there a similar formula that can be used.

As an example say there are 10 rows of data, the dates with time are in column A, I want to them count the number of entries per day for statistics. If anyone can help or needs a better example please let me know.

[TMS]

What error? What is the formula? What does your data look like?

Please post a sample workbook.

Regards, TMS

[Tony Valko]

Try something like this...

To count the number of cells that contain today's date...

C2 = today's date = 7/9/2013

Then:

=SUMPRODUCT(--(INT(A2:A10)=C2))

[JimmyG.]

Thanks for the reply Tony, that works great however as the data will continue to grow I use a range list. In some of the cells as there isn't any data yet I use the formula =value(if(data!a1="","",data!a1)) which does what I need it to by not showing anything if there isn't anything there however that then causes your formula to come back as #NUM. is there anyway round this?

[Tony Valko]

Try this array formula**:

=SUM(IF(ISNUMBER(A2:A10),IF(INT(A2:A10)=C2,1)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.