Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Making due dates work days using DATEADD?

Topic Labels: Formulas
174 2
Showing results for 
Search instead for 
Did you mean: 

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.