Counting Dates

G

Guest

Hi,

I have a spreadsheet where in one column, some cells have dates, and some
are blank. I want to count all the cells that have the dates and exclude any
empty cells or cells that contain the header information. I have tried
=COUNT(A1:A100) and =COUNTA(A1:A100). I have even tried several other ideas
based on posts in this group, but the result always is 1/6/1900 instead of a
count. I can't imagine why this isn't working for me and would appreciate any
ideas you may have. Thanks.
 
G

Guest

Marie,

Your Counta formula will count all non-blank cells in your range. It is
showing 1/6/1900 because the cell is formatted as a date. Change the format
to general and you should get an answer of 153.

Just one point Counta will count any populated cell not just those with
dates in.

Mike
 
T

T. Valko

I have tried =COUNT(A1:A100) and =COUNTA(A1:A100).
Change the format to general and you should get an answer of 153.

How can you get 153 from a range of 100 cells? <g>

That's why I don't like it when people post ambiguous dates like 1/6/1900 or
6/1/1900.

To me, 1/6/1900 is "obviously" January 6 1900 = 6

To you, 1/6/1900 is "obviously" 1 June 1900 = 153

Biff
 
G

Guest

Thanks guys.....it worked! I changed the format to general and it worked
correctly. Mike, you're right....when I used COUNT, it gave me just the
number of cells populated with a date, and when I used COUNTA it included the
header row as well. I guess I'll use COUNT. Thanks again.
 

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

Top