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.