Hi all,
Hopefully someone can assist, i spent too much time messing about with this today
It should be simple, i have a spreadsheet that i want to circulate to several managers to track employee expenses, each manager has an annual budget.
So in Jan each month has the annual budget divided by 12.
Once jan expenses are in the over or under spend for that month then affects the monthly budget for feb and forward.
The wrinkle is that i have two months in the middle of the year in which special events are on that will require travel so the budgets in these months need to be higher, thus lowering the other months.
What i want is that the monthly budget in say april and may is the same as august and september (the months either side of the months with the special extra budget)
however the way my formula works isnt right for this.
Because its a sheet that will be sent out i want the manager to be able to put values in certain months to see how it will affect their budget for the rest of the year.
i have attached an example,
thank you in advance.
Bookmarks