Customer needs help with the following search. A search that will show the date that an item will not be available.
Customer has 200 on hand and three orders totalling 300.
Ship dates and quantities.
1-1 - 100, 1-10 - 100, 1—20 100.
Would like a formula to return the value of 1-20 as the day that will not have material available.