Date Specific Arithmetic

[ThatNewGuy]

Hello everyone,

I'm trying to create a "Bills" spreadsheet that calculates my monthly expenses and subtracts from my monthly income, current savings, etc. I would like to set my bills up with corresponding dates, and somehow have those bills deduct from a specific paycheck each month.

For example - any bills between the 1st and the 15th get deducted from my paycheck on the 15th. any bills after get deducted from my check on the 30th.

I've attached my basic *** spreadsheet, and I'm hoping someone can teach me how to do this!

Thank you so much in advance for your help =)

[Glenn Kennedy]

What do you expect to see? Where do you expect to see it? Please amend your sheet with manually calculated results in place and repost it.

[ThatNewGuy]

What do you expect to see? Where do you expect to see it? Please amend your sheet with manually calculated results in place and repost it.

I've highlighted the sections that I'm referring to and uploaded a newer version of the worksheet. I added a note that will clarify what I'm going for.

Thank you so much for the help, Glenn.