Counting just dates

  • Thread starter Thread starter john.menken
  • Start date Start date
J

john.menken

This is actually a two part question. I have a column that has text in
some of the cells and dates like 12/11 in others. How can I count the
number of cells with dates in them?

My second question is similar. I have a column with the text
"Attended" in some cells and "Unattended" in others. How can I count
all the cells with the word "Attended" in them? Thank you very much.
 
If ONLY dates and text, since a date is a number
=COUNTIF(A:A,">0")
same thing for question2
=COUNTIF(A:A,"attended")
 
Back
Top