Want it to be blank if date has not been added

  • Thread starter Thread starter KKJ
  • Start date Start date
K

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!!
 
Format cells in column A and B as date and add following formula in cel
B1
=IF(A1="","",A1+7)



Chris
 
Back
Top