Hi

I want to count the dates in a column that are less than today, so i am using:

=COUNTIF('AM Live'!H:H,"<="&TODAY())

But this returns the wrong value.
In column H is other data than dates and think this is causing the error.

At the moment it returns 88 but there are only 9 or so less than today???

Thanks

John