Skip to main content

How to modify this formula to ignore blank fields

  • January 27, 2022
  • 2 replies
  • 67 views

Forum|alt.badge.img+1

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

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • January 27, 2022
IF(
    {Due Date},
    DATEADD({Due Date}, 1, 'months')
)

Forum|alt.badge.img+1
  • Author
  • Known Participant
  • January 27, 2022

perfect thank you so much!!