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

%3CLINGO-SUB%20id%3D%22lingo-sub-1778313%22%20slang%3D%22en-US%22%3EAutomatically%20change%20daily%20view%20gantt%20chart%20into%20weekly%20view%20gantt%20chart%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1778313%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20expert%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%20an%20excel%20template%20for%20Gantt%20charts%20with%20a%20detail%20per%20date%20display%20format.%3CBR%20%2F%3EThe%20start%20date%20can%20be%20started%20on%20any%20date%2C%20but%20I%20always%20start%20the%20date%20of%20the%20Gantt%20chart%20from%20the%201st%20of%20the%20start%20date.%3CBR%20%2F%3EI%20want%20it%20to%20be%20automatically%20converted%20to%20a%20weekly%20display%20format%20based%20on%20the%20date%20range%20of%20each%20task.%3CBR%20%2F%3EThe%20weekly%20view%20I%20want%20is%20flexible%20according%20to%20each%20month.%3CBR%20%2F%3EExample%3A%3CBR%20%2F%3E-%20October%202020%20will%20appear%20for%205%20weeks%20(1%2F10%2F2020%2C%205%2F10%2F2020%2C%2012%2F10%2F2020%2C%2019%2F10%2F2020%2C%2026%2F10%2F2020)%3CBR%20%2F%3E-%20November%202020%20will%20appear%20for%206%20weeks%20(1%2F11%2F2020%2C%202%2F11%2F2020%2C%209%2F11%2F2020%2C%2016%2F11%2F2020%2C%2023%2F11%2F2020%2C%2030%2F11%2F2020)%3C%2FP%3E%3CP%3EMy%20difficulty%20is%20changing%20the%20date%20details%20to%20a%20weekly%20format.%3CBR%20%2F%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESony%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1778313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1778563%22%20slang%3D%22de-DE%22%3ESubject%3A%20Automatically%20change%20daily%20view%20gantt%20chart%20into%20weekly%20view%20gantt%20chart%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1778563%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F831408%22%20target%3D%22_blank%22%3E%40SonyBudiarso%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20may%20suggest%2C%20please%20add%20a%20file%20(without%20sensitive%20data)%20and%20describe%20your%20plan%20on%20it.%3C%2FP%3E%3CP%3EThe%20error%20could%20be%20identified%20faster%20and%20more%20specifically.%3C%2FP%3E%3CP%3EPlease%20no%20picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20is%20worth%20a%20thousand%20words%2C%20it%20is%20definitely%20not%20in%20the%20case%20of%20Excel.%3C%2FP%3E%3CP%3EThis%20means%20that%20you%20can%20be%20helped%20more%20quickly%20and%20the%20best%20possible%20solution%20tailored%20to%20your%20needs%20can%20be%20offered.%3C%2FP%3E%3CP%3ESo%20everyone%20is%20helped.%3C%2FP%3E%3CP%3EHelp%20to%20be%20helped.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20It's%20always%20good%20to%20add%20your%20operating%20system%20and%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1778743%22%20slang%3D%22en-US%22%3EBetreff%3A%20Automatically%20change%20daily%20view%20gantt%20chart%20into%20weekly%20view%20gantt%20chart%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1778743%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Niko%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20advice.%3CBR%20%2F%3EThis%20is%20an%20example%20I%20can%20give.%20Hopefully%2C%20it's%20clear%20enough.%3CBR%20%2F%3Ethanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESony%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1778811%22%20slang%3D%22de-DE%22%3ESubject%3A%20Automatically%20change%20daily%20view%20gantt%20chart%20into%20weekly%20view%20gantt%20chart%20in%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1778811%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F831408%22%20target%3D%22_blank%22%3E%40SonyBudiarso%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EQuickly%2C%20here%20is%20a%20file%20from%20the%20Internet%20with%20weekly%20division%2C%20maybe%20you%20will%20find%20in%20these%20suggestions%20for%20your.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EUnfortunately%2C%20cannot%20help%20at%20the%20moment%2C%20as%20other%20commitments%20call.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EBut%20I%20am%20almost%20certain%20that%20someone%20will%20contact%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPs.%20%3CFONT%20size%3D%222%22%3EThe%20third-party%20products%20that%20these%20article%20discusses%20are%20manufactured%20by%20companies%20that%20are%20independent%20of%20me.%20I%20makes%20no%20warranty%2C%20implied%20or%20otherwise%2C%20about%20the%20performance%20or%20reliability%20of%20these%20products.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3EFile%20is%20from%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.vertex42.com%2FExcelTemplates%2Fgantt-chart-template-pro.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.vertex42.com%2FExcelTemplates%2Fgantt-chart-template-pro.html%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.
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

6 Replies

@SonyBudiarso 

 

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)

Hi Niko,

 

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

 

Regards,

 

Sony

@SonyBudiarso 

 

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)

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

 

Regards,

 

Sony

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.


Nikolino
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!!