Thread: [Solved] Count the Number of Cells Containling Dates
View Single Post
 
Old 05-19-2019, 02:14 PM
skeezix skeezix is offline Windows 10 Office 97-2003
Competent Performer
  
Join Date: Jan 2019
Posts: 115
skeezix is on a distinguished road
Default
Quote:
Originally Posted by Logit View Post
CAUTION: This formula will count anything that is a number. If you column has more than dates and those entries are a number, this formula will count them as well.

=COUNTIF(A:A,">1/1/1900")

Thank you for your help. That formula works except I forgot to say that row A has a word in it, and I have 17 rows. Could your formula somehow be changed to eliminate row A in the count? Please see the image in the next post.
Reply With Quote