Creating a calendar with horizontal bar for time duration
Posted on 2014-12-25
First this isn't exactly a Gantt chart. Plenty of examples but not specifically what I am looking for.
Row 1 would display dates (F1(1/1/2015 for example) to never ending)
Row 3 (C3 Start date, C4 end date, and C5 Duration, which is C4-C3) The rows would also be limitless
Is there a way that the start date could find a matching date in row 1 and the intersection (cell) would be filled in then the number of duration would fill, horizontally, the remaining cells? If the duration is 3 days then 3 cells are filled in.
Thank you for any assistance