Day date glitch

[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?

[Toscanizzazione]

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?

EDIT:
here is solution https://community.airtable.com/t5/formulas/dateadd-pulling-the-count-from-a-lookup-field/td-p/139043