referencing date in a cell based on total paid

[BigDLizzle]

Hey Guys

I have a spreadsheet to track tutoring costs.

I want to show deposits/payments from a client, the date of these deposits being nondiscriminatory (I will sum these deposits on separate cell if necessary), and pull information as to a date they are paid up to.

Lets say I have these days(weeks):
8.09.2021 - 100$
8.16.2021 - 80$
8.23.2021 - 100$
8.30.2021 - 40$
9.06.2021 - 80$

The client has paid 280$ already. How can I have excel pull information that they've paid up to 8.23.2021 already. AND, if they pay the following weeks payment of 40$, how can I have it so it pulls the 8.30.2021 date...all in one formula hopefully.

I want to create a invoice, or running balance to be sent to the client on a monthly, or weekly basis.

Keep in mind that I'm creating this for my mother in-law to use, so I'm hoping I can sue excel, because she probably wont have the motivation to learn access, or any other program...AND it needs to be simple for her to use. I will lock whatever cells need to be locked, as to avoid having her input any formulas or the like

 

[hrayani]

Hi,
You can use helper column to add the subtotals

See if this helps....

VBA Working.xlsm
	A	B	C	D	E	F
1	DATE	PAYMENTS	HELPER COLUNM
2	9-Aug-21	$100	$100		PAYMENT	PAID TILL
3	16-Aug-21	$80	$180		$280	23-Aug-21
4	23-Aug-21	$100	$280
5	30-Aug-21	$40	$320
6	6-Sep-21	$80	$400
Sheet4

Cell Formulas
Range	Formula
F3	F3	=INDEX(A2:A6,MATCH(E3,C2:C6,0))
C2	C2	=B2
C3:C6	C3	=C2+B3