Tricky, because dates in Excel are just number of days since 01//01/1900, so
it is difficult to distinguish a date from any other positive integer number
If you set limits on the dates, say since 1970, and up until 2010, you could
use
=SUMPRODUCT(--(A1:A1000=--"1970-01-01"),--(A1:A1000<=--"2011-01-01"))
--
HTH
Bob Phillips
"MJMP" wrote in message
...
In a column, there are entries with dates (in MM/DD/YYYY format). How can
I
count the number of cells that have dates in them? I do not want to input
a
criteria for the date. I just would like the number of cells that have
any
date in it.
Thanks!
|