How to modify this formula to ignore blank fields

[Emma_Sousa]

Hi All
I have a formula I am using to take a date and add a month to it. The problem is that I specifically have some fields blank. Right now the formula works, but where there is a blank date field, it shows ‘error’. Is there a way to modify the formula, so it would ignore blank date fields and not display ‘error’?

DATEADD({Due Date},1, ‘months’)

Thanks
Emma

[kuovonne]

IF(
    {Due Date},
    DATEADD({Due Date}, 1, 'months')
)

Airtable Support

Common formula errors and how to fix them

When building formulas or using one of Airtable's computed fields, you may run across an error. These error codes include #ERROR, invalid formula, NaN, circular reference, and infinity. Below are m...

[Emma_Sousa]

kuovonne:

IF(
    {Due Date},
    DATEADD({Due Date}, 1, 'months')
)

perfect thank you so much!!