yande
New Member
Hi Master,
Can excel calculate the total of stock for selected date?
Here the story:
1) Balance stock in 31st Jan 2019 is 20.
2) 50 new stock up enter the warehouse on 2nd Feb 2019.
3) Stock sold on 5th Feb 2019 was 30.
I need to learn a formula that able to calculate the balance of stock when i select the date. For example:
1) I select date 30th Jan 2019. stock balance will appear 20.
2) i select date 1st Feb 2019, stock balance will appear 20.
3) i select date 3rd Feb 2019, stock balance will appear 70.
4) i select date 6th Feb 2019, stock balance will appear 40.
Note: My database for in and out stock was in same table.
Please help me. Teach me.
Tq so much in advance.
Can excel calculate the total of stock for selected date?
Here the story:
1) Balance stock in 31st Jan 2019 is 20.
2) 50 new stock up enter the warehouse on 2nd Feb 2019.
3) Stock sold on 5th Feb 2019 was 30.
I need to learn a formula that able to calculate the balance of stock when i select the date. For example:
1) I select date 30th Jan 2019. stock balance will appear 20.
2) i select date 1st Feb 2019, stock balance will appear 20.
3) i select date 3rd Feb 2019, stock balance will appear 70.
4) i select date 6th Feb 2019, stock balance will appear 40.
Note: My database for in and out stock was in same table.
Please help me. Teach me.
Tq so much in advance.