Find Date X Works Days Before/After

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!

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

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.

3 Likes

Good point @Kamille_Parks !

Thank you! I appreciate it!

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.