Skip to main content

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

  • March 14, 2022
  • 1 reply
  • 23 views

Forum|alt.badge.img+3

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

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @LaTrelle_Gomez ,

Instead of DateAdd you can use WorkDay