Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Nested IF using DATEADD, not woking and no error!

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


I have two fields, one contains a date, the other contains a frequency. Based on this I want to have a third field populated with the date of the next occurrence.

the first IF statement works and correctly sets the date, the second is ignored and no error. It just does not populate the field at all.

I am using the following:

IF(Recurrence = “Weekly”,DATEADD({Invoice Due Date},7,‘Days’,
IF(Recurrence = “Monthly”,DATEADD({Invoice Due Date},1,‘Month’))))

2 Replies 2

You’re missing a closed parentheses after your first DATEADD() function. :slightly_smiling_face:

Try this…

IF({Recurrence} = "Weekly", DATEADD({Invoice Due Date}, 7, 'day'), IF({Recurrence} = "Monthly", DATEADD({Invoice Due Date}, 1, 'month')))

Thank you! Not sure how I missed that but working good now :slightly_smiling_face: