Hi,

You could just use something like...

=COUNTIF(A1:A100,"01/01/1920")

Hope this helps,

Gav.

"msnews.microsoft.com" wrote:

Can anyone advise how to count the number of cells containing dates in the
range A1:A1000. Is there a condition I can use in COUNTIF?

If it helps, the dates are customer formatted as dd.mm.yy

Many thanks,

Jason