Date Ranges with Multiple Conditions?
I am trying to calculate time windows by referring to previously entered dates, but am unsure how to build a formula that takes into account multiple conditions.
For the highlighted cell, there are 2 conditions that I am trying to incorporate. For the first condition of "4 to 7 days after V3", I have the earliest date as: "=([Date Planned]9 + 4)" and then latest date as "=([Date Planned]9 + 7)". Is there a way to also include the condition "1 to 4 days after V4" in this row? If this was the only condition, the formula for the earliest date would be "=([Date Planned]10 + 1)" and then latest date "=([Date Planned]10 + 4)", but I am unsure of how to combine these with the formulas from the first condition.
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!