EXCEL - How do I make the cell stay blank until a date is entered in N7?

I have an excel sheet where a cell is =N7+60. How do I make the cell stay blank until a date is entered in N7?

Tim,

Try using the IF function where if the cell =60, display 0, otherwise use N7+60

I am using the cell to project a completed date, for example cell N7 (3/18/21) then cell N8 will be (3/18/21 + 60). However I would like to keep the cell N8 blank until a date is entered into N7?

Try this function.

"=IF(N7=0,0,N7+60)"

You can fake it with conditional formatting on N8, setting the font color to white if the cell value is between 0 and 60. There will still be a date in N8 but you won't be able to see it.

Tim,

I did some playing around. Try this instead:

"=IF(N7=0,"",N7+60)"

If that does not work, try using the term NULL instead of a zero. In some cases Excel sees zero and NULL differently.