Thread: Count of Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default Count of Dates

if your date coulmn is column A

=COUNT(a2:a100)

"Zoltan" wrote:

I have a column for entering dates. Not every cell has a date entered. Is
it possible to return a count of only the cells in the column which have a
date entered into them? i.e. If 6 cells in the column have a date entered,
return a count of 6. Thanks for your help.

Cheers!