Hi,
i need some help on adding data from today and adding it to the next day until end of month
example is
Aug 1 we have 100 Original data and only able to do 50. so i wanted the 50 excess to be added to the next day orignal data until end of month.
Aug 2 we have now the 150 Moving data (difference between original and actual) and we were able to do 250 actual data. so i wanted it to be added to the next day until end of month
Aug 3 we would only have 50 Moving data (difference between original and actual) ad we were able to do 50 actual as well.
and so on.
i hope my explanation is clear and represented properly with the excel file below
i need some help on adding data from today and adding it to the next day until end of month
example is
Aug 1 we have 100 Original data and only able to do 50. so i wanted the 50 excess to be added to the next day orignal data until end of month.
Aug 2 we have now the 150 Moving data (difference between original and actual) and we were able to do 250 actual data. so i wanted it to be added to the next day until end of month
Aug 3 we would only have 50 Moving data (difference between original and actual) ad we were able to do 50 actual as well.
and so on.
i hope my explanation is clear and represented properly with the excel file below
Book1.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2 | Orig Data | Moving Daily Data | Actual Data | Difference | |||
3 | 8/1/2023 | 100 | 100 | 50 | -50 | ||
4 | 8/2/2023 | 100 | 150 | 250 | 100 | ||
5 | 8/3/2023 | 100 | 50 | 100 | 50 | ||
6 | 8/4/2023 | 100 | 0 | ||||
7 | 8/5/2023 | ||||||
8 | 8/6/2023 | ||||||
9 | 8/7/2023 | 200 | 100 | ||||
10 | 8/8/2023 | 200 | 100 | ||||
11 | 8/9/2023 | 200 | 100 | ||||
12 | 8/10/2023 | 200 | 100 | ||||
13 | 8/11/2023 | 200 | 100 | ||||
14 | 8/12/2023 | ||||||
15 | 8/13/2023 | ||||||
16 | 8/14/2023 | 300 | 200 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E3:E5 | E3 | =D3-C3 |