Want it to be blank if date has not been added

[KKJ]

This should be simple: In cell A1 there is a date. in cell B2 I want to add
7 days to that date. But if I have not yet added a date in A1 I would like
B2 to stay blank.

I Can't seem to make that happen.

Thank You!!

 

[T. Valko]

Try this in B2:

=IF(A1="","",A1+7)

Format it as Date.

 

[Shane Devenshire]

Hi,

Here is another alternative

=IF(A1,A1+7,"")

 

[Chris Bode]

Format cells in column A and B as date and add following formula in cel
B1
=IF(A1="","",A1+7)



Chris

 

[KKJ]

Thanks to everyone!! worked great!

kkj