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.