Cells with dates...

E

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
 
M

Max

Evgenia said:
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.
Click to expand...

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)
 
B

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)
 
Top