How do you create a due date to be 4 business days prior to my send date?

[Molly_Chalmers]

We have to deliver our assets to our agency 4 business prior to a launch so I’m curious to know what kind of formula I put in to create these dates.

[Kamille_Parks]

Use WORKDAY()

WORKDAY({Launch date}, -4)

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

[Molly_Chalmers]

Thanks for the quick response. So in my case I did WOKRDAY({Send Date}, -4) but it came back with a message "Sorry, there was a problem creating this field. Unknown function names: WORKDAY

[ScottWorld · Accepted solution]

Kamille had a small typo above. Notice the spelling of WORKDAY in your formula.

[Molly_Chalmers]

Well I feel extremely silly for missing that. That resolved it for me. Appreciate everyone’s help.