All you have to do is create a Gantt Chart in Gantt Excel and click on the Weekly View button in the Gantt Menu. The weekly view will render instantly with the calendar displaying all the weeks of the year. We use ISO weeks for the week number calculation and views.

Enter the Project Start date and the Display Week you want to begin with. You can then enter the tasks for each phase of your project, the names of those responsible, and the start and end dates. As you add the Start and End Dates, you'll see the Gantt chart on the right update automatically.

To build a Gantt chart by week, you can use conditional formatting applied with a formula based on the AND function. In the example shown, the formula applied to D5 is: =AND((D$5+6)>=$B6,D$5<=$C6) When the expression above returns TRUE for a given cell in the calendar, the blue fill is applied.