View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Cells with dates...

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