I want to create a spreadsheet that will track the following:



Starting on 1 January I save 1p and each day thereafter I save the same as yesterday + 1p.

I want to keep a running total of how much is saved.

Depending on cashflow I want to be able to make deposits to this savings pot in bulk from time to time for example I might wish to make a payment today that will include the daily savings up to the 1st of next month so I want to be able to input the date 01/05/2022 and have the spreadsheet output how much I need to deposit.

I also want to be able to predict the value of my savings on any future date.

Can you give us 5 rows of example data that you would end up with? I'm not totally sure what you are doing. Just type the data in rows in a reply.

Unfortunately I am unable to upload an Excel file today.

Let's say the Columns are Date, Deposit, and Balance. Deposit in col B is when you make an additional deposit. Balance in col C is showing you the balance. So if there are headers in row 1, then your data would start in row 2.

Here's the formula for the balance starting in C2: =C1+B1+1

Column B is in pence since you are adding 1 pence per day in col C.

Where does this answer come from? is the OP PM'ing you?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Let's try this upload. Remove .txt file extension to see what I did.

Attached Files

Bank.xlsx.txt (8.9 KB, 9 views)

From your description it appears you already have the formula that will provide your answer.

I think the attached file may help you; your question is a very good example to apply the "Gauss" formula, hoping I understood your point .

Bank.xlsx