Making due dates work days using DATEADD?

Hi! I want to have due dates as work days only, but the formula below gives 5 days before the start date, NOT 5 working days.

IF({Start Date},DATEADD({Start Date},-5,‘days’))

Can someone please help me with the formula to make the due date of something 5 WORKING days before the start date?

Thanks in advance.

Page 1 / 1

Welcome to the Airtable community!

Look into the WORKDAY() function. It is documented in the Formula Field reference.

WORKDAY({Start Date}, -5)

Sign up