Hi, I hope someone can help me!
I have a workbook to keep track of my finances - I've set one sheet to total up my regular outgoings, and take it off what I earned that particular month. I have another that I put all my purchases in to, which tallies up how much I've spent in a particular week, and takes that off my budget for that week, showing me how much I have left.
However, I would also like a cell to tell me at a glance how much I have left to be taken out by my regular outgoings, based on the date. For example, say a payment goes out on the 22nd, how much is left to come out over the rest of the month - kind of like a money 'countdown'.
Is this possible, and if so, can some one help me with the formula please? The task is made more difficult (I assume) because of when I get paid - I get paid on the 20th of each month, so my wage has to split practically over two months.
I hope that was all understandable, if someone needs clarification on anything though, I'd be more than happy to do so!
Thanks
I have a workbook to keep track of my finances - I've set one sheet to total up my regular outgoings, and take it off what I earned that particular month. I have another that I put all my purchases in to, which tallies up how much I've spent in a particular week, and takes that off my budget for that week, showing me how much I have left.
However, I would also like a cell to tell me at a glance how much I have left to be taken out by my regular outgoings, based on the date. For example, say a payment goes out on the 22nd, how much is left to come out over the rest of the month - kind of like a money 'countdown'.
Is this possible, and if so, can some one help me with the formula please? The task is made more difficult (I assume) because of when I get paid - I get paid on the 20th of each month, so my wage has to split practically over two months.
I hope that was all understandable, if someone needs clarification on anything though, I'd be more than happy to do so!
Thanks
