Include Saturday as a WORKDAY?

[Kyle_Roll]

Hey all. I’m following this tutorial on auto calculating the end date based on the start date. I got it all working, but would like to include Saturday as a working day (so only exclude Sundays). I’m sure this is simple but keep getting errors in my formula. Here is the formula I’m working with which is based on the standard workday schedule:

IF(AND({Start date},{Duration (days)}),WORKDAY({Start date},{Duration (days)})){Duration (days)}

Thank you!

[Zack_S]

Hey Kyle,

Give this a try.

Include Saturdays in Weekday count? Ask the community

[exploded_sat_calc] Hi Neads, Here’s the steps so you can see it broken down, and a consolidated formula where the temporary variables have been removed. {start day} = WEEKDAY({Start Date}) {days apart} = DATETIME_DIFF({End Date},{Start Date},‘days’) {days until sat} = 6-{start day} {# sats} = ROUNDDOWN(1+({days apart}-{days until sat})/7,0) {consolidated} = ROUNDDOWN((1+(DATETIME_DIFF({End Date},{Start Date},‘days’)-(6-WEEKDAY({Start Date})))/7),0) Good luck!