Hi,
I have a spreadsheet for our personal finances.
There is a worksheet per month with a starting balance - all the monthly incoming and outgoing with a remainder total at the bottom.
3 columns if you will (date, description (insurance, wages, etc), amount (£)
The remainder total makes for the starting balance of the next months worksheet and continues until the end of the year.
I then take the final remainder figure and divide that by the remaining weeks of the year (I use the date diff formula and divide the days by 7).
This leaves me with a figure of spare monies I can use for whatever each week.
What I am trying to establish now is how I can run a formula to see if there are any weeks in which the spare money amount is not available or indeed if there is more than so I can hold it back for when required (this would be column D).
If anyone could please assist it would be greatly appreciated.
Bookmarks