Hi Everyone,
I want to create a spreadsheet which shows my current bank account balance. In the spreadsheet I want to have fields which show monthly outgoings. Under each month I will enter how much I have spent during a day on a specific thing, i.e. petrol. So once I have entered that amount I want my balance cell to minus that amount, however, I also want the balance cell to recognise when I get paid. So for example, if I get paid on the 28th of every month, I want the balance cell to plus the amount I get paid, (this amount will be the same every month) once the current date exceeds the 28th.
I have attached a spreadsheet which contains formulas which hopefully you can see and workout what I am trying to do. Please let me know if you need anymore information.
Thanks in advance.
Balance.xls
Bookmarks