Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate end date using number of days calculation excluding weekends

Topic Labels: Formulas
196 0
Showing results for 
Search instead for 
Did you mean: 

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