Counting just dates

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.
 
D

Don Guillett

If ONLY dates and text, since a date is a number
=COUNTIF(A:A,">0")
same thing for question2
=COUNTIF(A:A,"attended")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Date Count 2
PIVOT - COUNT IF "YES" 1
How-to apply conditional format 1
Count Values in a Range, Not Formulas 2
Counting dates but only for a certain year 2
Count cells if next column has text 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Count formula 5

Top