How to make a cell invisiable without deleting the formula.

There are a few ways.

1. You can update your formulas in Day1 to be part of an If() statement such as the one I gave you before....e.g. =IF(your_formula=0,"",your_formula) where your_formula is your current formula residing in the cells.

2. A more global way is to go to Tools|Options and in the View tab uncheck the "zero values" checkbox.

3. With Conditional Formatting. Select the entire range. Go to Format|Conditional Formatting and select Cell Value Is >> equal to >> =0
Then click Format and from the Font tab, select White from the colour pallet to match your sheet background. Click Ok. Click Ok again.

4. Select cells go to Format|Cells and select Custom from the Number tab. Enter: 0;-0; as type