Forum Discussion
Solved
Dependency formula changing dates - Excel Gannt
Hi When i add a dependency into column G, it will amend the start date in column H. What i want to happen is: If the 'End Date' in cell I13 is after the Ind.Start Date (cell E14), then i want ...
Does this do what you want?
=IF(ind_start_date="","",IF(d_id="",ind_start_date,MAX(ind_start_date,INDEX($I:$I,MATCH(d_id,$B:$B,0))+1)))
HansVogelaar please find workbook via the following https://we.tl/t-ZwkjMyMZxt
Does this do what you want?
=IF(ind_start_date="","",IF(d_id="",ind_start_date,MAX(ind_start_date,INDEX($I:$I,MATCH(d_id,$B:$B,0))+1)))
- this seems to work perfectly, many thanks