Adapt Gantt chart to exclude weekends

Hi everyone!

I need help in fixing this Gantt Chart.

So my company doesn't work on weekends and I've tried multiple formulas to exclude the weekends from this. Can someone please help?
I would want my days to continue with the exclusion of the weekends remaining blank in the middle of the days. Please help.

Don't tell us that it is URGENT, please. To you it may be, but to us it isn’t. If it’s urgent, you should be calling on a consultant, not a volunteer who is giving their free time.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I will do it for you today.)

I suggest you have a Finish date based WORKDAY rather then just adding number of days to start date.

You will obviously need to change the CF to reflect this calculation and to ignore weekends (and holidays?).