Budget Spreadsheet help!

[pickneters]

I have pretty much finished the spreadsheet...I dont know if this is even possible, but I would like to input the date of each paycheck and have my expenses calculate based on due dates. For example I get two pay checks and I want the bills due after paycheck 1 but before paycheck 2 to be calculated in my expenses for paycheck 1 and vice versa....

Is this possible?

ps my brain hurts

[rcm]

try this, I included all expenses before check one to be paid by check one's funds...

[pickneters]

That is pretty close to what I am trying to do...I get paid every 14 days so I want to be able to just enter in the date i get paid...so paycheck one pay for everything until i get paycheck two.....then paycheck two would pay everything until i get paycheck one...sorry if I am not explaining this correctly...

try this, I included all expenses before check one to be paid by check one's funds...

[pickneters]

lets try this again...

I need this as the criteria ...11>25 so anything greater than the value entered in B2 but less than the value entered in B3

That is pretty close to what I am trying to do...I get paid every 14 days so I want to be able to just enter in the date i get paid...so paycheck one pay for everything until i get paycheck two.....then paycheck two would pay everything until i get paycheck one...sorry if I am not explaining this correctly...

[pickneters]

I got check one to work but when I flipped the equation i cant get it to calculate check two...

lets try this again...

I need this as the criteria ...11>25 so anything greater than the value entered in B2 but less than the value entered in B3

[rcm]

so what do you do with the outstanding bills dated prior to check 1?

[pickneters]

so what do you do with the outstanding bills dated prior to check 1?

Paid with check 2

[rcm]

sorry I might be to slow today, but since there are only 2 checks I filtered the expenses from the 11 to 25 for check 1 and the rest was by difference from total expenses.

[pickneters]

Alwyas the simple stuff! lol

I guess libreoffice or googledocs doesnt like sumifs forumula....works great on my regular pc but when I try and use it on my laptop running linux or google docs it just errors out, any ideas?

sorry I might be to slow today, but since there are only 2 checks I filtered the expenses from the 11 to 25 for check 1 and the rest was by difference from total expenses.

[rcm]

Nope. I am not familiar with linux excell or google docs excel versions...

[pickneters]

You can replace sumifs with a longer forumula if your curious...just found it on openoffice's website...they said it fill be added in their next release...no info on google docs...

Nope. I am not familiar with linux excell or google docs excel versions...

[rcm]

i substituded the sumifs() for two sumif()

[pickneters]

i substituded the sumifs() for two sumif()

You sir are a gentleman and a scholar. I'm not very good at Excel yet, you've saved me countless hours. I start my Excel class next month so hopefully I can pay it forward in the future. I wish I could up vote you. ..

[rcm]

glad I could help, but one learns more from practicing and brainstorming....so thank you for the challenge too!!