Hi,
I am new to this,
I am creating a warehouse spread sheet with pallet no: storage days etc. As follows
Date IN Pallet no: Qty Storage days
29-07-16 123 1 3
30-07-16 144 1 2
01-08-16 154 1 0
I need to create a summary sheet with pallet no: and storage days
For example for the month July
Date IN Pallet no: Qty Storage days
29-07-16 123 1 3
30-07-16 144 1 2
Then invoice the customer
And next month end of August
Date IN Pallet no: Qty Storage days
29-07-16 123 1 31
30-07-16 144 1 31
01-08-16 154 1 30
Pallet no: "123" & "144" July storage days already invoice so it counts only Augusts.
And so on...
Please help me in writing the formula for the same
TIA
Bookmarks