Help

Making due dates work days using DATEADD?

Topic Labels: Formulas
1205 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jcas_spark
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

Welcome to the Airtable community!

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

Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer