Strange count if behaviour 2

[SmithyJD]

I have a list of date and times in coulmn A, in column B1 I have the formular =countif(A:A,">06/07/2013) which returns 133, in c1 I have 06/07/2013 and in c2 =countif(A:A,">C1") which returns 1.

Any ideas what I got wrong as I am scratching my head big time with this one

Thanks

JD

 

[strongm]

=COUNTIF(A:A,">" & C1)

 

[SmithyJD]

Dohhh remember being told that now must be my age.

Thanks for the reminder at least I have some hair left been pulling it out

 

[Andrzejek]

To recognize the help and to show appreciation to the helping person, it is customary at TT to use
[blue]
Like this post?
Star it![/blue]


Have fun.

---- Andy

 

[SkipVought]

Hmmmmmmm? Transmission of The King's English across the pond?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

Thanks for the star, but I did not deserve it.
You owe it to strongm for his help


Have fun.

---- Andy