Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to modify this formula to ignore blank fields

Topic Labels: Formulas
448 2
Showing results for 
Search instead for 
Did you mean: 

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’)


2 Replies 2
    {Due Date},
    DATEADD({Due Date}, 1, 'months')

perfect thank you so much!!