Hi everyone, my first post, and I'm fairly confident with Excel, but certainly not an accomplished expert.

I have a basic question regarding the design of a worksheet that would allow me to keep track of my personal finances.

I would like to build a worksheet that can contain the following:

1. The worksheet displays every day of a calendar month along with a cell that I can type in my bank balance for that month.

2. For every day, I can type in the amount of money I spent from my bank account that which is then reflected in the cell which has the total.

3. A seperate row or column that I can record potential online purchases that again would be subtracted from the cell which has the total.

Hopefully that makes sense - could any kind person give me a rough sketch of how to lay this out?

Many thanks for your time and patience,

Lyle