Skip to main content

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


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



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.


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



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.


Thank you Kamille!


Thanks & regards,

Sally


Sally de Witt

E: sally@3xlapparel.co.za

M: 071 671 8861

Reply


Terms & Conditions