Hi,
Producing a Gantt chart with dates running across the top row. Would like to pull back the earliest date and latest date based on what is in the cell below.

Basically if 1 is in the cell, it would pull back the corresponding date.


I am sure this is indexing and maybe matching but advice please....


Thanks,


-CL