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


--
Evgenia
------------------------------------------------------------------------
Evgenia's Profile: http://www.excelforum.com/member.php...o&userid=28946
View this thread: http://www.excelforum.com/showthread...hreadid=486802

"Evgenia" wrote:
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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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)


"Evgenia" wrote in
message ...

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


--
Evgenia
------------------------------------------------------------------------
Evgenia's Profile:
http://www.excelforum.com/member.php...o&userid=28946
View this thread: http://www.excelforum.com/showthread...hreadid=486802