Formula help

[onewingdove]

I attached a small clip of the cells I'm working with.

Ignoring the spacing between columns, let's call them Column A, Column B and Column C

What I'm trying to do is if:

Column A has a date, then Column C = Column A+7 days
Column A is blank, but Column B has a date, then Column C = Column B+7 days
If both Column A and Column B are blank, the Column C = blank

Closest I've been able to get:
=IF(ISBLANK(A1), B1+7, A1+7)

However, this does not account for BOTH being blank, which is what I'm trying to figure out.

There does not need to be a calculation if both Column A and Column B have dates, as only Column A or Column B are filled and never both

 

[Peter_SSs]

Your answers are always well thought out and without any logical flaws.

Thanks for your kind words, though unfortunately the above is not always correct.