BigDLizzle
New Member
- Joined
- Aug 12, 2021
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
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
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