Hi guys!
I have to do a weekly cash report:
<tbody>
</tbody>
I want to change only the dates and the formula would give me the final balances.
The database is as follows:
<tbody>
</tbody>
Maybe the formula would include something with a SUMPRODUCT or another formula. If anyone has any idea please share.
Thanks in advance!
I have to do a weekly cash report:
1 | 2 | 3 | 4 |
A | Balance as of | drop-down date (e.g. 1 sep 15) | 1xx0x (formula here. NOTE: end of the day balance) |
B | Cash in | 1xx1 (from day 2 and so on) | |
C | Cash out | -1xx2 (from day 2 and so on) | |
D | Balance as of | drop-down date (e.g. 10 sep 15) | 1xx0 (that's the simple part: A+B-C) |
<tbody>
</tbody>
I want to change only the dates and the formula would give me the final balances.
The database is as follows:
Data | Cash In | Cash Out | Balance |
1 sep 15 | 50 | 50 | |
1 sep 15 | 40 | 10 | |
5 sep 15 | 30 | 40 | |
10 sep 15 | 20 | 20 |
<tbody>
</tbody>
Maybe the formula would include something with a SUMPRODUCT or another formula. If anyone has any idea please share.
Thanks in advance!