Hi,

I have a spreadsheet set up with 2 worksheets. One
worksheet is for the "imported" data and the other is for
updating using cell referencing.

The only problem is that I want the "updated" spreadsheet
to calculate by using the =COUNT function. My problem is
that by the cells being referenced the calculation is
actually adding "blank cells" because of the formula (cell
reference).

How can I get my calculation to only add if there is an
actual "date" in the field and not add "cell referenced
formula's and/or blank cells"? Any suggestions. Thanks!