Income/Budget Calendar?

[Guinea]

I am not even sure if Excel is capable of performing the functions that I am looking for, but I figured I would try. If not, I would like to at least be pointed in the right direction. Basically I want a document that can take my input, like some of the Excel budget templates out on the internet today....



The difference is, I want it to be somewhat of a calendar that allows me to plan out my finances as of future income dates. For example, if I have 500 dollars now. I get paid 400 dollars every Wednesday. I want to be able to type in an income or an expense on the days of a calendar and have all of the calendar days display what my total amount will be, so I know if I will end up going negative.... Here is an example:

March 1 - 500 starting budget
March 3 - First wednesday, 400 deposit, net = 900
March 5 - Car payment, 200, net = 700
March 10 - Next wednesday, 400 deposit, net = 1100
March 13 - Insurance, 100, net = 1000

Obviously I want this in a clean calendar form, not just text. I know this is asking a lot, but if anyone has seen anything like this or could point me in the right direction, I would really appreciate it... Something like this would really help my finances and be able to plan my expenses much more clearly.

[BjornS]

Hi,
please look at the attachment. Does this do what you want?

Kind regards
Bjorn

[Guinea]

Actually, that is almost perfect. It is simple and provides me with just the information that I am looking for. I really appreciate you submitting that for me...

The only thing I was hoping for was to have that same information and method of displaying data, but in a calendar form. I don't know if that is possible, but it would make things a lot cleaner for me to actually visualize it in a calendar, so I could see Wednesdays and other days...visualize a 7 day period etc etc. Is that possible?

[BjornS]

Hi again,
here is a proposal for solution. See the sheet "Calendar". You still update on the sheet "budget".

Kind regards
Bjorn

[Guinea]

Again...very awesome that you are doing this for me. I actually took your first concept and put some of my own information to work. I found a calendar template that I really liked and put some of the same fundamentals into it... Here is what I was kind of talking about. Not sure if I could make it anymore systematic or clean, or if I could make the functionality any better...but this is kind of what I meant.