Help

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

Solved
Jump to Solution
1227 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sally_de_Witt
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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