Hello,

I have a summary spreadsheet. I have two columns that require consecutive
dates. (ex. 12 consecutive Mondays). These dates have to be fluid. If the
first date goes in B9, then B10 thru B20 need to autopopulate. I can do this
easily by putting =B9+7 in cell B10 and then dragging the handle down the
remaining cells.

I can lock the cell to keep the formula from being messed up or erased. Cell
B9 is the only one that needs to be able to have input. That's all been easy.

My problem is that when cell B9 is blank, then B10-B20 continue to display
results for the formula. In this case, since it's a date, they display the
range from 1/7/1900 to 3/17/1900. I don't want that range to display if cell
B9 is blank. Can this be accomplished?