Creating a formula for [date] subtract [specific number of days]

[Sally_de_Witt]

Hi there,
I want to add a formula to result in a date.
I have a delivery date column. and I want formula to calculate a date 7weeks (49 days) before the delivery date. I have this working in Excel & numbers, but copying the formula into Airtable does not work - results in NaN.
Please may you help.
Thank you,
Sally

[Kamille_Parks · Accepted solution]

Sally_de_Witt:

I have this working in Excel & numbers

Airtable’s formulas are not the same as Excel’s, or Numbers’, or Sheets’.

Airtable Support

Formula field reference

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

Your formula should either be

DATEADD({Delivery Date}, -7, "weeks")

or

DATEADD({Delivery Date}, -49, "days")

Make sure that your {Delivery Date} field is actually a date-type field.

[Sally_de_Witt]

Thank you Kamille!

Thanks & regards,
Sally

Sally de Witt
E: sally@3xlapparel.co.za
M: 071 671 8861