Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

# Dependency formula changing dates - Excel Gannt

Copper Contributor

# 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 the Start Date in cell H14 to change to one day after I13.
• However, if the end date in cell I13 is before the Ind.Start Date in cell E14, then the start date in H14 should remain as the Ind Start Date H14

Any ideas on how i need to amend

4 Replies

# Re: Dependency formula changing dates - Excel Gannt

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.

# Re: Dependency formula changing dates - Excel Gannt

@Hans Vogelaar please find workbook via the following https://we.tl/t-ZwkjMyMZxt

best response confirmed by Philip51617 (Copper Contributor)
Solution

# Re: Dependency formula changing dates - Excel Gannt

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)))

# Re: Dependency formula changing dates - Excel Gannt

this seems to work perfectly, many thanks
1 best response

Accepted Solutions
best response confirmed by Philip51617 (Copper Contributor)
Solution

# Re: Dependency formula changing dates - Excel Gannt

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)))