If you use COUNT it will not count blank cells. Similarly,

=COUNTIF(A:A,"<")

will count all cells in column A that are not empty.

Hope this helps.

Pete

On Feb 24, 9:23*am, Scoffers
wrote:
Investigated using COUNTIF but from what I can see you need to set specific
criteria i.e. an exact date rather than just a cell with any date in it.

I know I could count the blank cells and take them from the total number of
cells using COUNT but this is long winded.

Any help welcome.
--
Scoffers