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
Solved
Creating a formula for [date] subtract [specific number of days]
+1Best answer by Kamille_Parks11
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.
+27Airtable’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.
+1Airtable’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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.