Formula to determine what the next arrival date is for stock on order

Hello,
I have been trying to do a formula myself that will allow me to quickly see the stock i have ON ORDER and when it will be next arriving to our warehouse. as dates change often and orders are raised daily its hard to keep manually checking each Stock Code and the next arrival date, i would love a formula that can instantly tell me when its next arriving, so as soon as we add new orders, receive orders or change arrival dates we instantly have the formula update the information and i can report to warehouse staff.

COLUMN B "next arriving Qty"
This formula will return the qty that is next coming into the warehouse

COLUMN C "ETA Meubilair" the formula in here i would like so that it will reference the next cell with a qty in it, then refer to the DATES in ROW 7, and equal the date that is in that cell.

IE STOCK CODE 20265M , next arriving is 100 units on the 25/1/2021, so these are the results i would like the formula to say, then if orders are added or dates are changed the formula will calculate any changes and update the qty and the dates accordingly.

Column B and Column C will have formulas. THen i can use this information to quickly report to the team the latest stock arriving and the dates with easy reports based on this information.

THank you in advance.

See the attachment.

For the date, I have used a min(if( formula to return the minimum (soonest) date where the delivery quantity is not blank.

For the quantity, I have used an index match formula to identify the quantity arriving on that date.

Hope this helps.

SimonLock - Thank you so much, absolutely perfect exactly what i wanted. i really appreciate your help on this. you just made my day job so much more efficient and accurate now. cant thank you enough.

No problem, I have changed the formula to find the quantity to a sum if instead of an index match. This will work when there are multiple columns with the same date, which I think was the problem you were having.

See the updated attachment.

thank you so much appreciate the fast response to help me solve it. Im not too sure if that is working well though, the first row (8) should return a date of 26/01/2021 and a qty of 50?

In column CA you have a quantity of 85 arriving on 11/01/2021, and it is picking up this earlier delivery.

ah yes i see now, and IF there is a qty with the same date then its adding it. hence why row 11 is returning a figure of 420, VERY CLEVER!!!!!! i love this, thats something that i hadn't thought of but it makes sense now to have it adding if that qty is arriving at the same time. THank you so much, ill play around with it tonight and hopefully all is ok now.

thank you its working perfectly now. you've been such a great help. Enjoy your day.