automatic value change - monthly

[anonitachi]

Hey all,

This is just a wee personal project. I am wanting to have a dynamic SUM/date stamp that will change a value every month without manual input... if possible?

I have created a spreadsheet with my monthly bills. I have column B as 'Amount Owed' , column C as 'Monthly Payment' and column D as 'Amount Remaining'.

Basically I have the amount I owe minus the monthly payment which equals the amount remaining using =SUM(B3-C3) on D3.
Is there a way that when say, on the 30th of every month, the Amount Remaining will change automatically after the Monthly Payment is subtracted from Amount Owed?


Many thanks
Anonitachi

[teylyn]

Hello,

Excel does not change values automatically. In order to record monthly payments against a debt, it is common to state each payment in a table and calculate the balance. Consider this:

	A	B	C
1		amount owed
2		10000
3
4	Date	monthly payment	balance
5	1-Jan		10000
6	30-Jan	100	9900
7	28-Feb	100	9800

The formula in cell C6 is

=C5-B6

Copy down. Each month, enter a new row with the date and the monthly payment. The formula will calculate the balance of the debt.

cheers, teylyn

[teylyn]

Hello,

Excel does not change values automatically. In order to record monthly payments against a debt, it is common to state each payment in a table and calculate the balance. Consider this:

	A	B	C
1		amount owed
2		10000
3
4	Date	monthly payment	balance
5	1-Jan		10000
6	30-Jan	100	9900
7	28-Feb	100	9800

The formula in cell C6 is

=C5-B6

Copy down. Each month, enter a new row with the date and the monthly payment. The formula will calculate the balance of the debt.

cheers, teylyn

[anonitachi]

Thanks for the response