User Profile
SonyBudiarso
Copper Contributor
Joined Oct 13, 2020
User Widgets
Recent Discussions
Re: Averaging the same cell across multiple sheets
Hi Ayeziza , With the information you told me, I tried to make the sample file and =AVERAGE (January: December! F2) function properly. If it doesn't look what you mean, it would be better if you could include files to clarify what you want. Regards, Sony41KViews1like0CommentsAutomatically change daily view gantt chart into weekly view gantt chart in Excel 2019
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, SonySolved33KViews0likes10Comments
Recent Blog Articles
No content to show