Cells with dates...

[Evgenia]

Is it possible to count N of cells that contain dates? not a specific
date, but any date? e.g. in one column there are cells with dates and
abbreviations, and those with dates need to be counted.

thanks for help!

-Evgenia

 

[Max]

Is it possible to count N of cells that contain dates? not a specific
date, but any date? e.g. in one column there are cells with dates and
abbreviations, and those with dates need to be counted.

Assuming the col contains only real dates and text (without any other
numbers), then we could use COUNT (dates are numbers)
Example, in B1: =COUNT(A:A)

 

[Bob Phillips]

You still have responses in your other thread, there is no need to re-post
just because the first suggestion isn't exactly what you wanted.

--

HTH

RP
(remove nothere from the email address if mailing direct)