Help me make a simple Excel table please?

[ChipInTheSugar]

My nonexistent skills aren't up to even this simple task

I need a simple Excel table: column 1: regular incomings; column 2: regular outgoings (standing orders, DDs, petrol, food, etc); column 3: running balance.

But I need/want to be able to add in miscellaneous outgoings, and to be able to see what effect that's going to have on the month ahead, if you see what I mean. So I can see what my balance is/will be in any given day in the month ahead.

Can anyone tell me what formulae to put where, pretty please?
(Of course, if there's an app that does this, that would be grand.)

I use Excel to track incoming and outgoings. Columns a to e are from my online bank statement (date, description, paid out, paid in and balance. Then to the right I have for each month my monthly outgoings plus any ‘non budgeted’ spend on the end. Use a formula like this one to get the last value in the column from your bank statement and then a simple - on the cell you are subtracting. Use a negative integer for any credits. =LOOKUP(2,1/(E:E""),E:E)

When you sum, sum the entire column, o eg =sum(D:D)
That way if you add extra lines in for additional purchases they will be included

Just as the pp has done in fact!
So many people think you must set the start and end row, eg D2:D17. I rarely find that helpful.

Op do you mind if I hijack your thread please? I need to do a spreadsheet that turns red after a set time. Eg if I put in column A 01/01/20 and the column is set for a year (2019) it needs to turn red. The next column might be 3 years etc. Work have got one that I use but nobody knows who created it so can’t help me when I need to add extra columns. Thank you in advance.
apologies op

conditional formatting, OneUsername? I think google that.

Thank you, Utility and Stealth