Calculate a due date by weeks

[Brian_Paul]

Hi everyone.

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.

Brian.

[Sam_Cederwall · Accepted solution]

Hello Brian,

If I understand you correctly, I think we can use the DATEADD formula to set this up.

Based on your specifications I set up a test base:

I then created a formula in the first column that looks like this:

Your first field here will then be the number of planning weeks before the departure date. Hopefully I was helpful and able to answer your question sufficiently.

[Brian_Paul]

I am so impressed with this community! You solved it and so fast. Thank you so much.