Find Date X Works Days Before/After

[Greg_Wasserstro]

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!

[Julian_E_Post]

Hi 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

[Kamille_Parks]

You 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.

[Julian_E_Post]

Good point @Kamille_Parks !

[Greg_Wasserstro]

Thank you! I appreciate it!