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.
Best answer by Sam_Cederwall
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.
+17Hello 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.