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.

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

"Marie" wrote:

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.

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

"Mike H" wrote in message
...
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

"Marie" wrote:

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.

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.

"Marie" wrote:

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.