I have 3 Columns. DUE DATE, PLANNING WEEKS & DEPARTURE DATE
I want to use a formula that sets the DUE DATE by looking at the DEPARTURE DATE and subtracts the number of PLANNING WEEKS.
In other words, I want to automatically set my DUE DATE of each task by the PLANNING WEEKS before we depart(DEPARTURE DATE).
I hope this makes sense.
Thank you so much. This will save us hours of planning.