Hello,
I have created a budget tracker that allows me to forecast a balance based on the number of days entered. It works but I have only been able to forecast up to 31 days into the future. I would like to be able to forecast up to a year, more if possible. I have attached a copy and any help would be much appreciated. Please ignore the comments they are their as a guide for my missus and if the cells need changing for it to work please do.
Thanks
Reef
Hi,
What makes you think it's not working. Changing C39 to say 365 days forecasts wages for the next year.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
Thanks for the reply.
The wages will rise but the outgoings only calculate for the first 31 days as the sheet only calculates the next due date. I would like to be able to calculate the outgoings also over the set period on the same days based on the frequency column.
Reef
Would you offer a couple of examples so that we can understand your request in context. Tell us how many days you plug in and say what the results should be in whatever cells should change and explain the calculation if it's not blindingly obvious.
Sorry for not replying sooner. I have worked on this and used VBA to solve the problem. Thank you for your interest
Reef
OK glad you solved it yourself in which case please select Thread Tools from the menu link above and mark this thread as SOLVED. You might also like to consider posting the solution you came up with in case anyone else with a similar problem is looking for an answer in the future.Originally Posted by Reefaman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks