Looking For A Formula - Noob

[d4funky1]

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.

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[d4funky1]

my word - how many of your 8000+ posts are the same as your last.

Rather than throwing the rule book at me why not offer a solution

Poor forum - i'll go elsewhere.