This is the formula that this forum taught me awhile ago to deal with a complex problem:
What I have realised is that I actually have more than 1 date changing event. So I wondered whether I could make this formula more complex by adding an OR function perhaps (I am guessing here)?
I don't think this will work, and I am hoping someone can offer a suggestion or solution.
If context helps. I will try and give an example of what I am trying to achieve (please ignore the fact that the entire set-up is illogical):
The package will be delivered 14 days after order was made: 27/01/2015 (Date1)
What day range are you not available? 23/01/2015 (Date2) to 29/01/2015 (Date3)
What day range is no-one available? 22/01/2015 (Date4) to 31/01/2015 (Date5)
Date1 will need to be amended (hence my original code) depending on whether Date2 is before or after the delivery date.
The problem I have now is that I need to do the same for Date4, and if at all possible, within the same cell.
Any help would be appreciated as always.
Bookmarks