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.

I hate to send you elsewhere, but if you DAGS...

Excel workday function 6 day workweek...you'll get lots of hits. Array formulas, non-array formulas, UDFs, etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you for your help. Solution found.

Ask Your Question

Weekly Poll