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 column but since they are dated 6/30/2021 format, it won't let me. Is there something else I should be trying?
1 Reply
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.
