Dependency based on column

Sbott

Hi. I am hoping I am submitting this into the right area. I have a project that has columns instead of rows that are dependencies. I am needing the due dates to factor in only working days. Is there a setting or formula that can make this work. The columns are below. Thanks in advance

• Start Creating Content - 11/7/22 (duration is 10 working days)
• First Draft Due (dependent on the completion of Start) 11/18/22 (duration 2 days)
• Review Returned (dependent on the completion of First Draft Due) 11/22/22 (duration 2 days)
• Video Due (dependent on completion of Review Returned) 11/25/22 (duration 3 days)
• Finish and Upload Content (dependent on completion of Video Due) 11/28/22 (duration 1 day)

Captain Cowtown

Hi,

I believe you can use the WORKDAY function to accomplish your goal. It works this way =WORKDAY(Original Date, # of workdays to add, range of holidays you would like excluded).

Does this help?

Captain Cowtown

Hi,

I believe you can use the WORKDAY function to accomplish your goal. It works this way =WORKDAY(Original Date, # of workdays to add, range of holidays you would like excluded).

Does this help?

Sbott

Thank you @Captain Cowtown That is what I needed