Skip to main content

Calculate end date using number of days calculation excluding weekends

  • February 28, 2022
  • 0 replies
  • 7 views

Forum|alt.badge.img+3

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