Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

I need to add a number of weekdays only to generate an end or due date

Topic Labels: Formulas
438 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am looking to take an integer and add the number to a start date. I need to have weekends excluded from the date add. Please see the formula I am currently using that isn’t generating the result I need:

IF({Workflow}=“Manufacturing”, DATEADD( DATEADD({Start Date}, {Estimated Production Days}, ‘days’), SWITCH( WEEKDAY( DATEADD({Start Date}, {Estimated Production Days}, ‘days’) ), 0, -1, 1, -2, 0 ), ‘days’ ))

1 Reply 1

Hi @LaTrelle_Gomez ,

Instead of DateAdd you can use WorkDay