Help

How to add days to a date?

Topic Labels: Formulas
Solved
Jump to Solution
18510 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Julie_Anne_Stam
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Julie_Anne_Stamps ,

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

See Solution in Thread

7 Replies 7
Mohamed_Swella1
13 - Mars
13 - Mars

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.

jelica
4 - Data Explorer
4 - Data Explorer

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?

Toscanizzazione
4 - Data Explorer
4 - Data Explorer

Hi,
i've got problem using DATEADD(). Base printscreen in attachment.

Column: Data wystawienia is a Date  (date of invoice)
Column: Kredyt kupiecki is Lookup from other table (table with contractors) and is a Number
Column: Termin platnosci is formula:

DATEADD({Data wystawienia (zakupu)},{Kredyt kupiecki},'days')
but formula is not working. 
 
If i use exactly the same formula but in "Calculation" paremeter in DATEADD i use different column with Number - it's working fine.
But if i use Lookup field - formula is not counting.

Any ideas?