hide zero values in date formatted cells

  • Thread starter Thread starter Teri
  • Start date Start date
T

Teri

Cannot find way to hide the value in cells that have a
formula (in Date format). Example: User will enter a
date in cell A1. Cell A2 and below will be a sum(A1+1)
and copied down. The entire column is in a date format.
But we want it all blank until user enter date in A1.
 
One way:

You can't do this with formatting, since, with no entry in A1,

=A1+1

(you don't need the wasteful SUM() wrapper) will = 1, not zero.
Instead, change your formulae to

A2: =IF(A1="","",A1+1)

and copy down.
 
Back
Top