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

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’ ))

Hi @LaTrelle_Gomez ,

Instead of DateAdd you can use WorkDay

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.