Excel Gantt chart limited to 52 weeks – how to extend to multiple years?

Hello,

I was recently asked by my manager to create a project planner along with a Gantt chart. To do this, he asked me to try the default templates available in Excel, which I did.

However, after spending an entire day entering all my projects, details, and phases, I realized that the timeline is limited to 52 weeks.

I really don’t want to start everything over in a new Excel file, so I’m looking for a way to fix this issue.

The main problem is the following:
there is an automatic Gantt chart that generates the timeline when I enter the start and end dates, but I don’t know how it works. I need to modify the formula so it can adapt to a multi-year timeline, but I’m not sure how to do that or what the best approach would be in my case.

I hope someone can help me with this.
Thanks in advance!