Forum Discussion
Excel Formula help
Hey Guys Hope all are well. I need to formula and I'm having trouble. So if A is a date. If B,C,D say yes I want to add 2 weeks on from A into E. If that makes. thanks in advance.
How would I work this for multiple options. EG if Yes its +14 but if its no its +7
Clearly as your requirements get more complex the solutions will need to be reworked to capture the intent of the formula. At the moment, a simple modification will suffice. I have converted the input to a Table so that it grows with new data. The result is a separate dynamic array which will grow along with the Table.