Recording Interest in spreadsheet accounting for Deposits/Withdrawals from Balance

[fdiddy]

Hi All,
See attached a tracker that i am trying to create that tracks interest accrued, cumulative interest but also accounting for withdrawals/deposits

The end result is i want to enter a balance in Col F at the end of each week and to calculate the interest received less the sum of the Deposits/Withdrawals.

Proving trickier that i thought but maybe cos its a Saturday!

Thanks all

Interest_Tracker.xlsx
	A	B	C	D	E	F	G	H	I
1		Start Date	13 December 2021
2		Start Balance	$13,632.03
3
4
5
6
7	Year	Date	Week	Weekly Interest	Cumulative Interest	Balance	Daily Interest	Deposits	Withdrawals
8	2021	13-Dec-21	Week 51	$0.00	$0.00	$13,632.03	$0.00	$0.00	$0.00
9	2021	20-Dec-21	Week 52	$77.97	$77.97	$13,610.00	$11.14	$500.00	-$600.00
10
11
12
13
14
15
16
17
18
19
20
21
1

Cell Formulas
Range	Formula
A8:A21	A8	=IF(F8="","",YEAR(B8))
B8	B8	=IF('1'!F8="","",C1)
C8	C8	=IF('1'!F8="","",("Week "&(WEEKNUM('1'!$B8,2))))
D8	D8	=IF(F8="","",'1'!F8-C2)
E8	E8	=IF('1'!$F8="","",D8)
B9:B21	B9	=IF('1'!F9="","",B8+7)
C9:C21	C9	=IF('1'!$F9="","",("Week "&(WEEKNUM('1'!$B9,2))))
D9	D9	=F9-SUM(H9,I9)-F8
E9:E21	E9	=IF('1'!$F9="","",D9+E8)
D10	D10	=IF(F10="","",((F10-H10-F9)))
D11:D21	D11	=IF(F11="","",'1'!F11-F10)
G8:G21	G8	=IF(F8="","",D8/7)

 

[fdiddy]

In the above Cell D9 this should be Sum(deposits/Withdrawals)less the current balance to give interest received for that week - Hope it makes sense