Removing weekends from Gantt Chart

An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

It looks like your whole method is to work backwards from an end date. Usually scheduling is done forward, but we can work with this.

You are calculating the start date by subtracting the lead time from the end date. To consider only working days in determining the start date, use this in I14 and copy down:

Formula:

Please Login or Register  to view this content.

The +1 is to include both the first and last days of the range as full work days.

I'm not sure why you have both "Lead Time" and "# of Work Days" because the way you are calculating them they will always be the same. I would just delete "# of work days" but for completeness, the correct formula for # of work days is

Formula:

Please Login or Register  to view this content.

Your list of dates starting in column P could also be adjusted to show only weekdays but you didn't mention that above.

In addition to ignoring weekends, you can also easily ignore holidays (both WORKDAY and NETWORKDAYS directly support this) but you would need to provide a list of holidays somewhere in your file.

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Originally Posted by vlosier

Did you find a solution for this? I'm having the same issue.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Originally Posted by kpromero

Sorry, I was trying to help and solve drinu and vlosier issue

You are not at fault here, apologies if it came across that way. The forum has a rule against a member asking a question on another member's thread - this is what vlosier did, and I have brought that rule to their attention. This is called hijacking.

If a member has their post moderated because they hijacked, then it stands to reason that any follow-up threads to that hijacking will also be moderated. Once theyu start their own thread, Im sure your suggestion will prove most valuable to them there