|So if I want to calculate project periods by adding working days I normally use the formula WORKDAY(start_date,days,holidays).|
This is normally fine, however it only deals with 5 day working weeks (i.e. Monday to Friday). What if i have a project on which we are working Monday to Saturday, which is a 6 Work Day week. Is there a simple way of formulating this.
For instance if I want to know a date which is 12 workdays later than Thursday 24th September 2015, I want the answer to be Thursday 8th October 2015, and not Monday 12th October 2015, that =WORKDAY will throw back.