Thread: [Solved] Count the Number of Cells Containling Dates
View Single Post
 
Old 05-19-2019, 07:05 AM
skeezix skeezix is offline Windows 10 Office 97-2003
Competent Performer
  
Join Date: Jan 2019
Posts: 115
skeezix is on a distinguished road
Default Count the Number of Cells Containling Dates
I have a one-column list that contains 10 cells of dates. Some of the cells are empty. I would like a formula that gives me the total number of cells that have dates in them.
For example, if cells A1 through A5 have dates, and cells A6 through A8 are empty, and cells A9 through A10 have dates, the result of the forumla would be 7.

How can I do this?
Reply With Quote