How to add days to a date?

[Julie_Anne_Stam]

I am trying to use this to automatically add 15 or 5 days to the contract date. The “calculation” field is an IF statement to calculate which amount of days to add. BUT I cannot figure out how to get the formula to add the days and give me a new date.

[Mohamed_Swella1 · Accepted solution]

Hi @Julie_Anne_Stamps ,

The formula for adding a date is DateAdd({Contract Date},Calculation,‘days’)

[Julie_Anne_Stam]

Its still not working the way I am wanting

[Kamille_Parks]

Notice how the formula you entered was not the one suggested to you. DATEADD() needs to be told the unit of measurement of time to be added. As @Mohamed_Swellam said, you have to tell it to add 'days' to the end.

[Julie_Anne_Stam]

Thank you! I missed that.

[Kamille_Parks]

No problem. I would suggest marking Mohamed’s reply as the solution since it was the actual answer to your question.

[jelica]

Hi! I am trying to match the above, but I keep having an issue with the days actually populating correctly - they should be adding from the column Number of Days, which should add the total number of days represented there. Does anyone have any ideas?