Show zero in a cell

Just a suggestion,

If you give a Yes to a later answer, that is the same as an earlier answer,
you should go back and click yes for each of those early "correct" answers.
Its just to be fair to Max, Eduardo, or NBVC, since the Microsoft site tracks
the number of answered questions based on this, they never actually look at
each question and answer, they rely on the user feedback.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Clare" wrote:

Hi

I have the undernoted formula, however, when cell H3 has no date in it the
cell with the formula shows 5714 can anyone tell me how to make the cell show
0 when there is no date in cell H3.

=SUM(NOW()-H3)/7

Thanks