Making a field dependent on another

[Sam_Greenberg]

Hi!
I am new to Airtable. I am currently setting up an Airtable spreadsheet and one field (column) has a date. Is there any way possible to make the column next to it show what date it will be 2 weeks later?

Regards,
Sam

[andywingrave]

Hey! Yep - You can use a formula:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

DATEADD(Date, 14, 'days')

[Sam_Greenberg]

How would I tell the system which column to add it from @andywingrave? It says that it is not valid.

[andywingrave · Accepted solution]

This is the field/column to use:

Replace the word “date” with your field