Count the Value between dates
Dear Expert,
I've a sheet showing
In Date (1-feb-08) - 100pcs
Out Date (3-feb-08) - 20pcs
Out Date (6-feb-08) - 15pcs
Out Date (10-feb-08) - 5 pcs
Out Date (14-feb-08) - 10pcs
My question is is there a formula to check a) what is my balance stock
between 5-feb-08, or 12-feb-08 or any date which I may need to check.
Tks / Nahc
|