Hi,
I have found this excellent way of creating a gantt chart using conditional formatting here on the site.
I have made som small changes as I would like to base my gantt chart on week numbers instead of years as used in the example. The week numbers are based on a dates using the WEEKNUM function.
The gantt chart works perfectly if the start- and end dates (in my case week numbers) are within the same year. However, if the start date is in 2015 and the end date is in 2016 the problem arises.
Even though I would like to have the output based on week numbers, I have the actual start and end dates in my data so I think it should be posssible to find a solution - I just can figure it out.
I have uploaded a sample file here.
I have found this excellent way of creating a gantt chart using conditional formatting here on the site.
I have made som small changes as I would like to base my gantt chart on week numbers instead of years as used in the example. The week numbers are based on a dates using the WEEKNUM function.
The gantt chart works perfectly if the start- and end dates (in my case week numbers) are within the same year. However, if the start date is in 2015 and the end date is in 2016 the problem arises.
Even though I would like to have the output based on week numbers, I have the actual start and end dates in my data so I think it should be posssible to find a solution - I just can figure it out.
I have uploaded a sample file here.
