Automatically change daily view gantt chart into weekly view gantt chart in Excel 2019

New Contributor

Hi expert,


I currently have an excel template for Gantt charts with a detail per date display format.
The start date can be started on any date, but I always start the date of the Gantt chart from the 1st of the start date.
I want it to be automatically converted to a weekly display format based on the date range of each task.
The weekly view I want is flexible according to each month.
- October 2020 will appear for 5 weeks (1/10/2020, 5/10/2020, 12/10/2020, 19/10/2020, 26/10/2020)
- November 2020 will appear for 6 weeks (1/11/2020, 2/11/2020, 9/11/2020, 16/11/2020, 23/11/2020, 30/11/2020)

My difficulty is changing the date details to a weekly format.
Thank you.





10 Replies



If I may suggest, please add a file (without sensitive data) and describe your plan on it.

The error could be identified faster and more specifically.

Please no picture, even if it is said that a picture is worth a thousand words, it is definitely not in the case of Excel.

This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered.

So everyone is helped.

Help to be helped.


* It's always good to add your operating system and Excel version.



Thank you for your understanding and patience.




I know I don't know anything (Socrates)

Hi Niko,


Thank you for the advice.
This is an example I can give. Hopefully, it's clear enough.







Quickly, here is a file from the Internet with weekly division, maybe you will find in these suggestions for your.
Unfortunately, cannot help at the moment, as other commitments call.
But I am almost certain that someone will contact you.


PS. The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

File is from:


Thank you for your understanding and patience.




I know I don't know anything (Socrates)

best response confirmed by Hans Vogelaar (MVP)

It has been solved by combining the weekday and eomonth functions.





I am glad that you found a solution yourself.

I wish you a lot of fun with Excel and your plans.

For further questions I am gladly at your disposal.

Thank you for your patience.

I know I don't know anything (Socrates)

Hi @SonyBudiarso would you be able to share your combined function in a file? I tried to do this, since I'm facing the same issue, but couldn't figure it out. Many thanks!!

@SonyBudiarso --- would you mind sharing how you solved this issue?
Hello N.. I saw your excel sheet.. was helpful. Would you be able to guide me on how to put that scroll bar to run d weeks as it's shown on your file. Thanks in advance


How would I add a scroll bar into this macro in exel with the use of VBA microsoft

You will find instructions on how to add a scrollbar to your workbook. create yourself


Overview of forms, Form controls, and ActiveX controls on a worksheet

Important: This feature isn’t available in Office on a Windows RT PC.

Want to see what version of Office you're using?

More informations in the upper Links.


Also included an example file where you could do your tests yourself.


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.




@SonyBudiarso can you please share the file with me? I am having the similar challenge....need to change daily gantt chart to weekly and then to monthly for long duration projects.