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]

"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
--

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


"Evgenia" <Evgenia.1yujjm_1132575902.6662@excelforum-nospam.com> wrote in
message news:Evgenia.1yujjm_1132575902.6662@excelforum-nospam.com...
>
> 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
>