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

[Jul Stev]

try to see attached file, hope it helps

XL formula help required for Inventory aging.xlsx

[Kushi.Krishnappa]

Tons of Thanks to Mr. Jul Stev for helping me in creating the formula

Its fantastic formula, which i was hatching my head since from 2 months

regards,
Kushi

[Kushi.Krishnappa]

Tons of Thanks to Mr. Jul Stev for helping me in creating the formula

Its fantastic formula, which i was hatching my head since from 2 months

regards,
Kushi

[Jul Stev]

No problem, glad i could help