Sep 09, 2022 03:59 AM
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.
Sep 09, 2022 05:29 AM
Welcome to the Airtable community!
Look into the WORKDAY()
function. It is documented in the Formula Field reference.
Sep 09, 2022 05:34 AM
Formula Field Reference - Overview | Airtable Support.
WORKDAY({Start Date}, -5)