How can I create a Gantt chart in Excel where weekends are skipped and task bars update automatically when start dates change?

I’m trying to build a simple Gantt chart in Excel for a project plan.

My data looks like this:

Task        Start Date    Duration (workdays)
Design      2026-08-10    5
Build       2026-08-17    10
Testing     2026-08-31    4

I want the chart to skip weekends, so if a task has a duration of 5 workdays, it should only cover Monday through Friday and not include Saturday or Sunday.

I’d also like the task bars to update automatically when I change either the start date or the duration. Ideally, this would work with formulas or conditional formatting rather than manually editing the chart every time.

What is the best way to set this up in Excel?