Skip to main content

Making due dates work days using DATEADD?

  • September 9, 2022
  • 2 replies
  • 120 views

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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • September 9, 2022

Welcome to the Airtable community!

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


Zack_S
Forum|alt.badge.img+17
  • Inspiring
  • September 9, 2022