Solved How tio add 6 day working weeks to a date in excel

September 23, 2015 at 18:14:47
Specs: Windows 7
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.

See More: How tio add 6 day working weeks to a date in excel

Report •

September 23, 2015 at 19:06:55
✔ Best Answer
I hate to send you elsewhere, but if you DAGS...

Excel workday function 6 day workweek'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.

Report •

September 23, 2015 at 19:17:27
Thank you for your help. Solution found.

Report •

Related Solutions

Ask Question