Help

Calculate end date using number of days calculation excluding weekends

Topic Labels: Formulas
659 0
cancel
Showing results for 
Search instead for 
Did you mean: 
LaTrelle_Gomez
4 - Data Explorer
4 - Data Explorer

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

0 Replies 0