10-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
10-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)
10-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
10-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)
10-25-2020 11:52 PM
It has been solved by combining the weekday and eomonth functions.
Regards,
Sony
10-26-2020 12:15 AM
01-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!!