View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Clare Clare is offline
external usenet poster
 
Posts: 32
Default Show zero in a cell

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