Hi

=COUNTIF(A:A,"22/8/2009")

or use a cell ref where b1 contains the date

=COUNTIF(A:A,B1)

Mike

"count celld with date and time" wrote:

Hi, could somebody please help!

cell contain date and time
e.g. " 22/08/2009 14:34"

loads of them in the same column lets say column "A"

I have 5000+ cells per day transfered from another system,

I need to know everyday, how many of these 5000 cell iin column A is from
22/08/2009, 23/08/2009, 24/08/2009....etc (can ignore the time)

I have tried using formula
=SUM(COUNTIF(A:A,{"22/08/2009"}))

but it does not work, as the time within the cell is causing non exact
match, is there a way to go round this, and count how many cells is from each
date?
I have formated the cell to show dates only but the cell still contain time,
and still does not work!

all your help is greatly appreciated, thx a million