Forum Discussion
Formula to Calculate Daily balances
I am struggling to create a stock balances file where I can easily know the closing balances PER DAY, and what I need to borrow from the Main store as explained in the file. I have attached the file...
Starting in row 4 and filling down it looks like you could use:
=P3+5000*N4-I4
and I would further recommend replacing the 5000 in this case with a fixed location where the Transfer Size is stored, so something like $Z$1 if you store that in cell Z1
=P3+5000*N4-I4
and I would further recommend replacing the 5000 in this case with a fixed location where the Transfer Size is stored, so something like $Z$1 if you store that in cell Z1
- Thank you.
My main problem is that I have filled in the quantities in columns N & O manually. Would it be possible to have a dynamic formula in this cells that would update as items are being issued.- Item Code store qty
CHEM1 main 10
CHEM1 issuing 965
CHEM1 main -400
CHEM1 issuing -1300
how about keeping record in one sheet and then pivot table?I have edited the file again and I think if I could have the closing balances of the previous day become the new Opening balances of a new day, then I can manage to move on from there. Please see attached updated file. The file can be changed completely and not a must to appear the way it is. Important for me it to use the closing balances of the previous day as the new balances of the new day.
thanks
