Stock Balance with Certain Expiry Date: Will It Be Enough for Remaining Months?

[Thet Naing]

Hello,

My 1st day and I need your expert support on how to write a formula for Stock Balance with Certain Expiry Date - whether it can cover for remaining months required quantity (Consumption for remaining months.)

[ If we look only the Balance Quantity on "F9", it would cover as requirement under Forecast "C9" Quantity. But, having expiry date on the product, we would not able to cover "C9" Quantity and required 800 more on "G15". My request is to create1 or 2 formulas only for all remaining 6 months (I will apply for 12 months), calculating for each month forecast with Balance Quantity with Exp date. So that we will know whether Balance Quantity will cover all months and if not cover, required quantity will show up after calculation. ]


I have attached file for your support.

Thanking in advance.