I am trying to build a calendar whihc functions similarly to a Gantt Chart. In the attached examply, I have a line which has a Start Date, and End Date and a duration. The chart to the right captures when the activities occur. I have created a formula which captures the Start Date in the chart, but not sure how to be able to cature the Start, End and Duration in the chart. In this example, the Start Date is July 7th and the End Date is July 30t. The chart wich shows the week of July 2nd is populated, but I need the follow weeks up to July 30th needs to be populated.
Thank you for your help