exclude formulas when counting cells
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.
|