My only guess is that some of your dates are actually text, and not values.

Here's a formula which will count both text dates and dates.. if this works
you should probably check over your cells for text dates.

=SUMPRODUCT(--ISNUMBER(DATEVALUE(A1:A10)))+COUNT(A1:A10)



"CiCi Bird" wrote in message
...
Hi Dave R.
I am counting the number of cells that contain a date (01/01/05 for
example), but each cell contains a different date. All other cells are
blank
with no conditional formatting other than each cell is formatted for a
"date". Does this provide the info you need? Thanks so much! CiCi

"Dave R." wrote:

You don't say what you want to count but I guess dates. Dates are
values,
and count counts values, so maybe your dates are not values? Or your
"blank"
cells contain some numbers and are hidden by conditional formatting?



"CiCi Bird" <CiCi wrote in message
...
I have one column of over 100 cells that are either blank or contain a
date.
If I use the following, it doesn't add them up correctly.
=COUNTIF(G2:G113,"*") or
=COUNT(G2:G113)