Hi,
In a base, I have a column called {Launch Date}. I would like create a new column that contains the date X work days before {Launch Date}. I do not know this date in advance and want this new column to generate it!
Thanks!
Find Date X Works Days Before/After
+13Hi Greg!
You can achieve this by using a formula field with the Datetime_Diff function. Here’s documentation on how to use it: https://support.airtable.com/hc/en-us/articles/226061308-Supported-unit-specifiers-for-DATETIME-DIFF
LMK if you run into any challenges setting this up
+27You actually don’t want the DATETIME_DIFF() function as suggested by @Julian_E_Post.
You would accomplish this with a Formula field using WORKDAY({Launch Date}, -x), where “x” equals the number of days. The subtraction symbol ensures the formula gives you that number of workdays before x as opposed to after it.
+13You actually don’t want the DATETIME_DIFF() function as suggested by @Julian_E_Post.
You would accomplish this with a Formula field using WORKDAY({Launch Date}, -x), where “x” equals the number of days. The subtraction symbol ensures the formula gives you that number of workdays before x as opposed to after it.
Good point @Kamille_Parks !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.