On 6 July, 16:15, 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

Hi Clare

=IF(H3="",0,SUM(NOW()-H3)/7)

Regards

Steve