Help

Calculate a due date by weeks

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1835 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Paul
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Sam_Cederwall
7 - App Architect
7 - App Architect

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:

Due Date Base Example

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

Due Date Formula

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.

See Solution in Thread

2 Replies 2
Sam_Cederwall
7 - App Architect
7 - App Architect

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:

Due Date Base Example

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

Due Date Formula

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
4 - Data Explorer
4 - Data Explorer

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