Please provide an example to only count the cells with dates. I was using
the count function but it counts the cell if there is a date or text or
number in the cell. So my count was incorrect when I added the IF formulas
to the cells.

"T. Valko" wrote:

To count DATES use the COUNT function. Dates are just numbers formatted to
look like dates.

=COUNT(A1:A4)

Note that this will count *all* numbers, not just the "dates".

A1 = 8/12/2008
A2 = 10
A3 = 37
A4 = 9/27/2002

=COUNT(A1:A4) = 4

If you only want the "dates" counted then you'd have to narrow down the
dates to a range so that the result would exclude entries like A2 and A3.

--
Biff
Microsoft Excel MVP


"JayDee" wrote in message
...
Is there a "count" formula that will only count the DATE entry in a cell
and
exclude the formula in the cell?

A1, A2, A3, A4 have =if(isblank) formulas linked to another file. If a
date
auto populates in cell A1 and A4, the count should be 2. However, the
current count formula used in the spreadsheet shows 4 because the formula
counts any data in the 4 cells.