How do I count blank cells in a column of dates?
Andrea,
worked like a charm.... Awesome!!!!
Ron
-----Original Message-----
Click in the cell where you want the answer and type
=COUNTBLANK(B1:B5)
(replace B1:B5 with the range of cells containing your
completion dates and
blanks).
Andrea Jones
"Ron" wrote:
I have a column of dates... I am essentially counting
the
amount of time that has elapsed from the point that the
case was assigned to the date it was completed... This
I
figured out... What I want to do is count all of the
incomplete cases.. by way of counting the empty
cells...
Please be aware that I am not a very advanced user..
please try to dumb it down.
Thanks,
Ron
.
|