How to put together two formulas to account for blanks

Lisi · 05/30/19

Hello,

I have this formula to add 10 days to a date:

=[Date1]@row + 10

Then I have this formula to leave blank if there is no date:

=IF(ISBLANK([Date1]@row), "")

I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in [Date1]@row.

Thank you!

Andrée Starå · 05/30/19

Hi Lisi,

Try something like this.

=IF(ISBLANK([Date 1]@row); ""; ([Date 1]@row + 10))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Date 1]@row), "", ([Date 1]@row + 10))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Lisi · 05/30/19

Hi,

Thank you for answering but while working on another issue something told me to do this:

=IF(ISDATE([Completion Date]3), [Date1]@row + 10, "")

and it is working perfectly now.

Thank you!!

Andrée Starå · 05/30/19

Excellent!

Happy to help!

There is almost always more than one way to solve a problem.

A slight modification to the formula if everything is on the same row.

=IF(ISDATE([Completion Date]@row), [Date1]@row + 10, "")

Best,

Andrée

Formulas and Functions