Help

Nested IF using DATEADD, not woking and no error!

Topic Labels: Formulas
1495 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Hooper
4 - Data Explorer
4 - Data Explorer

Help!

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
AlliAlosa
10 - Mercury
10 - Mercury

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: