How to add days to a date?

Julie_Anne_Stamps · February 3, 2021, 5:40pm

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_Swellam · February 3, 2021, 5:55pm

Hi @Julie_Anne_Stamps ,

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

Julie_Anne_Stamps · February 3, 2021, 5:51pm

Its still not working the way I am wanting

Kamille_Parks · February 3, 2021, 5:55pm

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_Stamps · February 3, 2021, 5:55pm

Thank you! I missed that.

Kamille_Parks · February 3, 2021, 5:56pm

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

system · February 6, 2021, 5:56pm

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