XL formula required to calculate months GAP

[Rajani Krishnappa]

Hello Buddies,

I have come up some typical problem of preparing the planning/procurement sheet.

My procurement planning is based on seasonal medicinal herbs, when was preparing the sheet, I have stuck with from next coverage month to till next season starts, what is the gap in terms of months?

Basically I wanted to derive at how many I want to plan & procure the materials (considering seasonality).

Please help me with the formula to frame, it’s very important as if I miss any season, my complete planning will be shattered.


Screen shot as mentioned below.
[TABLE="width: 1286"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Descrption[/TD]
[TD]Total AOP[/TD]
[TD]Total skt[/TD]
[TD]Open PO Qty[/TD]
[TD]AOP Per month req[/TD]
[TD]Coverage status[/TD]
[TD]Season[/TD]
[TD]Season starts from[/TD]
[TD]Season Ends[/TD]
[TD]Coverage Month[/TD]
[TD]Procurement month[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]325665[/TD]
[TD]100966[/TD]
[TD]36000[/TD]
[TD]27139[/TD]
[TD]5[/TD]
[TD]Mar- Jun[/TD]
[TD]Mar[/TD]
[TD] Jun[/TD]
[TD]Mar-18[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]279877[/TD]
[TD]36713[/TD]
[TD]11000[/TD]
[TD]23323[/TD]
[TD]2[/TD]
[TD]Nov- Jan[/TD]
[TD]Nov[/TD]
[TD] Jan[/TD]
[TD]Dec-17[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD]206732[/TD]
[TD]57530[/TD]
[TD]76000[/TD]
[TD]17228[/TD]
[TD]8[/TD]
[TD]July- sep[/TD]
[TD]Jul[/TD]
[TD] sep[/TD]
[TD]Jun-18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Formula required in such a way[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]From next month of coverage month to next season starts [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Formula should result in "How many months material needs to be procured)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]& main idea is to ensure there shouldn’t result in shortage[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]If we miss the season whole planning will be collapsed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



regards,
RK