Oct 13 2020 11:58 PM
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.
Example:
- 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.
Regards,
Sony
Oct 14 2020 01:27 AM
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.
Nikolino
I know I don't know anything (Socrates)
Oct 14 2020 02:14 AM
Hi Niko,
Thank you for the advice.
This is an example I can give. Hopefully, it's clear enough.
thanks.
Regards,
Sony
Oct 14 2020 02:46 AM
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:
https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html
Thank you for your understanding and patience.
Nikolino
I know I don't know anything (Socrates)
Oct 25 2020 11:52 PM
SolutionIt has been solved by combining the weekday and eomonth functions.
Regards,
Sony
Oct 26 2020 12:15 AM
Jan 15 2021 03:03 AM
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!!
Mar 30 2021 07:36 PM
Aug 18 2021 03:23 AM
Aug 18 2021 04:00 AM
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.
Nikolino
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.
Aug 15 2022 08:24 AM
@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.
Oct 25 2020 11:52 PM
SolutionIt has been solved by combining the weekday and eomonth functions.
Regards,
Sony