How to write the Formula for calculation day of inventory when month has change

Dear Expert person,

Can you help me to advice me how to write the formula or Macro for calculation day of inventory?

I have the example data in this attached file.

How can write formula if I select Month of DOI at B1 as 1 = Jan then Formula will calculate by use unit forecast start from Jan onward to calculate DOI.

if i select 2 = Feb then formula will calculate by use unit forecast start from Feb onward to calculate DOI.



Thank you in advance for help me.

Can you give an example of the result for Jan and Feb

Please see this Excel that I seperate case of Jan and Feb.

If i select month at dropdown list is 1 = JAN then calcutaion will use Unit Forecast start from Jan

If i select month at dropdown list is 2 = Feb then calcutaion will use Unit Forecast start from Feb

Why for JAN formula sprends until MAY and nor APRIL if we need to cover 30 for Brand A?
Why formulas are not different for brant A, B, C ?
Explain what you what the macro to do.

Actually I need to write formula stop when ending stock less than unit forecast. but when i write the easy excel i use formula is cover until May first because of in the real life some brand is over 150 days, and i will copy formula at Brand A to other brand.

See how next function can help

Please Login or Register  to view this content.

Thank you for you answer but i try to change dropdown list at B2 but i get the same result eventhough i select 1 or 2

I am not sure I have to add some field or adjust anything.

Best Regards.

Yes there is a miss
Try

Please Login or Register  to view this content.