Stock with Expiry v/s Consumption / Production.

Dear Team,

I have a file contain two sheets with the stock list (Batch Wise) with Expiry Date, ,and the other sheet contain Month wise consumption. I need a formula or method which can help me if my existing stock will be expire before consuming or will be consume. and how much stock will be expire. Sample file is attached. In this sample file first sheet has stock qty with expiry date and the second sheet contain consumption month wise.I need any formula / method that can give me expiry quantity as highlighted in sheet.

Regards,


Imran.

Dear Sir,

This is the same post, due to your previous reply I thought that may be I have post my thread on the wrong page that's why I posted it again on the General page. I am really sorry for inconvenience.


Regards,


Imran.