View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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

.