Forum Discussion
How to get sum of number of cells that are dates?
I tried putting in SUM, SUMA, and SUMIF formulas but it keeps generating new dates or errors since I'm trying to add date cells together. I am just trying to count the total number of cells for that ...
If you want to count the number of non-blank cells in a range, use
=COUNTA(range)
Since dates are stored as numbers in Excel, you can also use COUNT:
=COUNT(range)
The latter formula will ignore all text values in range.