Calculating Stock and Order levels by date for past and current periods

[fazunus]

Hi Everyone, 

I want to present the level of stock and order of  product units in point of time by day for past and future .

I have the data which has the Order date, receive date and sold date. Attached below and the output desired is as below, the unit is considered on order if the it has been received by the date and not yet been sold, order unit is not yet received.

Thanks in advance.

Stock No	Product Code	Order Date	Receive Date	Sale Date
114743	A	01/06/2021	10/06/2021	14/06/2021
114748	B	02/06/2021	13/06/2021	30/06/2021
114722	A	03/06/2021	30/06/2021	15/07/2021
114332	B	04/06/2021	10/07/2021	30/07/2021
114728	A	06/06/2021	30/07/2021	29/08/2021
114774	B	07/06/2021	09/08/2021	13/09/2021

Output Desired:

		01/06/2021	02/06/2021	03/06/2021	04/06/2021	05/06/2021	06/06/2021	07/06/2021	08/06/2021	09/06/2021	10/06/2021	11/06/2021	12/06/2021	13/06/2021	14/06/2021	15/06/2021	till to date
A	Stock	0	0	0	0	0	0	0	0	0	1	1	1	1	1	0
	Order	1	1	2	2	2	3	3	3	3	2	2	2	2	2	2
B	Stock	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1
	Order	0	1	1	2	2	2	3	3	3	3	3	3	2	2	2