I need a blank cell!

[spearleyez]

Hi everyone,

I hope that my question comes across properly.

I have three cells, one cell has a date the next cell a number (for an amount of days, like 5) and the final cell has the formula. When a date is entered into the first cell, the formulated cell adds the number to the date. So say 2/10/10 + 5 = 2/15/10.

It all works fine, however when there is no date entered into the first cell, the formulated cell auto populates a date like 1/1/1900. I want the formulated cell to show as blank until a date is entered into the first cell. Is there a way to keep the formula but show a blank until infomation is added to calculate?

Thanks!

 

[Jonmo1]

Welcome to the board..

Try
A1 = Date
B1 = # of Days to Add
=IF(A1,A1+B1,"")

 

[spearleyez]

Thanks Jonmo1. I think I should paste my formula so that it may be easier to understand what I am doing.

=WORKDAY(C12,D12,$K$5:$K$11)

So where would I put the "IF" statement?

 

[Jonmo1]

Should be

=IF(C12,WORKDAY(C12,D12,$K$5:$K$11),"")

 

[spearleyez]

THANK YOU!!! I don't know the logic of why that formula works (because I can only do simple formulas) but it works!!! You're the best, thanks for being so quick about answering my post.

 

[kross27]

Can anyone help?! I have a date column in column C I then have a column for a date 2 weeks later in F and in G 6 weeks later, I want F & G to appear blank until a date is inserted into C, I then want F to calculate 2 weeks and G to calculate 6 weeks. I have tried to figure it from reading the previous posts but have been unsuccessful.

Thanks in advance