Help

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

How to add days to a date?

Topic Labels: Formulas
Solved
Jump to Solution
7972 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

image

1 Solution

Accepted Solutions

Hi @Julie_Anne_Stamps ,

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

See Solution in Thread

5 Replies 5

Hi @Julie_Anne_Stamps ,

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

Its still not working the way I am wanting
image
image

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.

Thank you! I missed that.

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