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)))
Please attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.
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