Skip to main content

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

IF(

{Due Date},

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

)






perfect thank you so much!!


Reply