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

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

You can refer to a cell containing a date:
=COUNTIF(B:B,A2)
returns how many times date in A2 occurs in column B!

The other part of your post is not understandable for me, please specify it
in details, possibly with an example!

Regards,
Stefi

€žScoffers€� ezt Ã*rta:

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

Since real dates are just numbers
=COUNT(A:A)
would be easiest, provided the col is clean data containing only real, valid
dates
(btw, blank cells won't affect COUNT)

If the data could be mixed, ie real dates interspersed with zeros or other
real nums which are not valid dates, something like this should provide more
robust results, ie check it within a known, valid date range, eg:
=SUMPRODUCT((A1:A10=--"5 Jan 2009")*(A1:A10<=--"18 Jan 2009"))

High-five? Click Yes below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"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.

=SUMPRODUCT(--(A2:A200=start_date_cell),--(A2:A200<=end_date_cell))

--
__________________________________
HTH

Bob

"Scoffers" wrote in message
...
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

=COUNTIF(A1:A100,"="&B1)-COUNTIF(A1:A100,""&C1) if your limits (inclusive)
are in B1 and C1.
--
David Biddulph

"Scoffers" wrote in message
...
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