How can I add a column to subtract weekends from the overall date range
I have a mix bag of vendors doing work, some have 7 day work weeks while other have 5 day work weeks, and I need them all laid out on the same Calendar.
I haven't found a way to mesh those two together nicely, so my though process was to: set up the work week as 7 days, and add a New column left of the "Duration column: (total days of work, weekends included)", but in this new column it would subtract all the weekend days (giving me the actual working days for my Vendors who only work 5 days a week)
I'm not even sure if this is possible, but any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!