Help with Auto-populating dates

Hi Kelly,

My company has static completion dates for projects with tasks that need to be completed a certain amount of time before the completion date. 

The way that we do this is with Completion Date, Due Date, and Date Mod columns.

So, if a task is due 14 days BEFORE the Completion Date, I set [DateMod]1 to -14. Then I use the following formula in [DueDate]1 : 

=[Date Mod]1 + $[CompletionDate]$1

This calculates -14 days from the Completion as the due date.

The dependencies didn't fit our needs since the Completion Date would sometimes change. This formula automatically updates all of our due dates when those changes did occur. I hope this may be helpful!

Cheers,

Jennifer

Happy to help!