Hiding formual values other than zeros

[Gadgetman]

Is there a way to hide formula values other than just zero values?

For instance, I have a time sheet that I developed for my company that
show's the 7 days of the week. In it folks enter the day of the month.
I would like to revise it so that they only need to enter the first
day and have the rest fill in by using a formual (ex: A1+1 etc), but I
dont want the values showing until the first date is entered. Without
being able to hide the values until the 1st day is entered, the
remaining day's now have values of 1 thru 6 showing.

Thanks for any insights.

 

[JE McGimpsey]

Is there a way to hide formula values other than just zero values?

For instance, I have a time sheet that I developed for my company that
show's the 7 days of the week. In it folks enter the day of the month.
I would like to revise it so that they only need to enter the first
day and have the rest fill in by using a formual (ex: A1+1 etc), but I
dont want the values showing until the first date is entered. Without
being able to hide the values until the 1st day is entered, the
remaining day's now have values of 1 thru 6 showing.

One way:

Assume A1 is your initial date. Enter

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

and copy over as far as required.