XL formula for finding the Aging of the Inventory

[Kushi.Krishnappa]

Hi Experts of this Blog,

Please help me in fixing the formula for finding the aging of the Inventory with the Batch Number (1st albhabet in the batch number says year of produced & 2nd alphabet in the batch # say month of produced) & depending upon the aging and in further coloums it should be categorised into whether it falls within bucket of 0-3months/3-6 months/6-9 months/9-12 months/> 18 Months.

Please go through the attached XL sheet & help me to fix this problem.

Tons of thanks in advance.


regards,
Kushi