Build a custom Gantt chart focused on week commencing dates

Feeling constrained by traditional Gantt charts that use weekdays for scheduling?

3 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

A Reddit user named Chunkychips127 recently asked a straightforward question: how to build a Gantt chart that shows week commencing dates instead of the usual Monday-through-Friday columns. The request is simple, and the answer should be too. Yet the fact that this question exists tells us something important about the gap between what people need and what traditional spreadsheet tools deliver.

The user is not asking for a radical new feature. They want a timeline view that matches how real project work actually unfolds. Most teams don't plan tasks by individual days; they think in weekly blocks. "Week commencing" is the natural rhythm of stand-ups, sprint reviews, and status updates. A Gantt chart built around that cadence makes planning more intuitive and reduces the noise of empty daily columns. The problem is that conventional spreadsheet software treats the daily grid as the default, and customizing it requires manual formulas, conditional formatting, and patience most people don't have.

This is where the real opportunity lies. Chunkychips127's question points to a broader frustration: users are forced to adapt their workflow to the tool instead of the other way around. They are not asking for more complexity. They are asking for a spreadsheet that understands how they think. An AI-native spreadsheet can solve this by letting users describe their desired view in plain language. Instead of digging through template libraries or writing nested formulas, you simply say, "Show me a Gantt chart grouped by week commencing," and the tool builds it. The intelligence is in the interface, not in the user's willingness to learn arcane functions.

What does this mean for you? It means the next time you need a custom view, whether it is a Gantt chart, a pivot table, or a dynamic dashboard, you should not have to search Reddit for instructions. You should be able to explore a solution that adapts to your context. The technology to do this exists now. The only question is whether you are using tools that still treat every Tuesday as a separate column, or tools that let you focus on the work itself. Chunkychips127 is not alone in wanting a better way. The answer is not a template. It is a tool that listens.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I need a Gant Chart but with 'week commencing' instead of the typical M T W T F. Does anyone know where I can find a template for this or how to make one myself?

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community