Combining two formulas to stop blanks returning errors

I’ve created a formula to subtract no.of days from a date, this has worked, however a number of the fields are blank so returning an error, I’ve created a separate formula for that too which also works, but I don’t know how to join them together in the same formulae?

DATEADD({Date auto-renew goes into effect},-{Auto renew notice period},‘days’)

IF({Date auto-renew goes into effect}, " ")

Hi @Becky_Taylor - you can combine these like this:

IF({Date auto-renew goes into effect}, DATEADD({Date auto-renew goes into effect}, -{Auto renew notice period},'days'))

Which is saying:

“if the date field is populated, then do the DATEADD formula”

You’ll notice that there’s no empty field ("")noted in the IF statement. You only need to provide this if there is an alternative value. If you just want it to be be blank if there’s no date field populated, then you can leave this out.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.