Formula for updating monthly budget

[Mhicks89]

I'm trying to create a budget sheet for a project I'm working on. I've decided on how to divide the budget each month into 50% going into critical spending that I can't avoid and 30% going into a more flexible spending account. I'm trying to divide the "30%" into weekly spending and I've figured out how to adjust that budget if I have overflow from the 50%

My problem I'm having is that If I notice a trend in spending more than my "50%", I want to be able to adjust the the percentages to reflect the new budget for future months. So far I have the following equation "

Please Login or Register  to view this content.

," where B21 represents the current date and B25 and B26 represent the start and end dates for that particular month (the 500 is just a place holder for the Capital while I figure out the equation). I've figured out how to Stop the formula from calculating if the date has passed, however I need it to update a change for future months and not effect previous months. For example if in March 30% works then in April I decided to adjust to 25%, I need March to stay at 30, April-December to become 25, then April to stay at 25 when/if I decide to update the budget again in the future

If anyone can help with my problem, I would be very grateful

[AliGW]

Administrative Note:

Welcome to the forum.

Please attach a sample workbook - there are clear instructions at the top of this page.

Members will tailor the solutions they offer to the version (NOT release number like 2112) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.