Fifo Logic ?

[#1]

HI All,

I have QNTY field, I have a Flag field(Issued & Received)..

Received-Issued =Total Stock QTY as on Today..

Total QTY must be Put in to the buckets as per Received wise (FIFO) for finding Age of that QTY

0-3 Months,3-6 months,6-9 Months,9-12 Months,1-2 Years,2-3 Years,3-4 Years,> 4 Years...

Find the attached Excel for Data..

Regards,

Helen