Calculate end date using number of days calculation excluding weekends

I believe the “SWITCH” function was probably not the proper tool for what I am trying to do. Here is what I did:
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’ ))

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