Forum Discussion
Gantt chart date formula
I have a row listing the dates of weeks commencing for each month. I want the Gantt chart to fill each block if the date occurs in that week. At the moment, it won't fill if the start date isn't ...
Riny_van_Eekelen Hi I want to use this for 57 weeks so how I can manage Year carry over.
e.g start week of one task is 502019 and ends in 062020, for another task start is 062019 ends 052020.
also any suggestion of working out to have both dates/days and weeks on same sheet where I can choose visibility option days or weeks.
Thanks.
Kashibaba Can you upload the file with the example of a task carrying over a year-end and with the conditional formatting based on my latest response? Then I don't have to do it all over again, as I did not retain the file I worked on previously.