Leave Cell Blank Until a Value Is Added

Question

I have a formula that calculates how many weeks are due (Cell C12) based on a due date I enter (Cell B12). I want to copy the formula in other rows on Column C but if I don't enter a due date in Column B some random number pops up on the Weeks Due column. How do I hide the formula in Column C until a due date is entered into Column B.

Updated spreadsheet:

Solution

The formula to use is:

=IF(B12="","",($B$5-B12)/7)

You say IF cell B12 is empty leave this cell empty, and if it contains something then do the calculation of ($B$5-B12)/7

Comments

[vivamaymartian]

Thanks you sooooo much! Last question...is there a formula I can add to the STATUS Column to either show it being Overdue (if due date is passed today's date) or In Progress (if it has not yet passed todays' date)?

[Yisroel Tech]

(If my answer answered your question please accept it as the answer.) I'm not sure I understand your last question, can you rephrase it, maybe with an example?

[Yisroel Tech]

And what about the new question? Or maybe do a new Question on the site for it.

[n8te]

@vivamaymartian - you still haven't marked his answer as Accepted. Hover your mouse to the left of his answer, underneath the number with up/down arrows and click Accept.

[bgStack15]

This answer is more readable than what I used to use. I did the reverse, which is more confusing: =IF(AND(B12<>"",B12>0),($B$5-B12)/7,"")