Subtract the value in column A if between two numbers

Im working on a budget and financial calculator

Ive already got it set up to calculate my pay and deduct taxes and all my bill and tell me how much i have left at the end of the month, now im trying to get it set up to tell me how much will be left out of each check i get based on what day my bills are due

Essentially what i want is I7 is the cell for my first check of the month and K7 is my second check, Collumn H shows my due dates for each bill, collumn A is the price on each bill so what i want is something that is similar to

If the value if column H is between 5 and 19 then deduct the price in column a from I7 (wwith H and A being the same row) and if the value of column H is 1-4 or 20-31 then deduce the value in column A (with H and A being the same row) from K7

another way to put it would be I7 gets duducted the value in column A if column H is between 4-19 otherwise do nothing (with H and A having same row)
deduct the value in Column A from K7 if column H is between 1-4 or 20-31 otherwise do nothing

A workboook sample would be helpful. but try this.

Formula:

Please Login or Register  to view this content.

My budget.xlsx

here is my document

right now i am manually subtracking them but i want something more automatic based on what number is in the H colum

Not exactly sure if this is what you are looking for. basically what I did was in column M there is a formula that will look at the date if it is between 5-19 it will return T otherwise it will return F. J7 has a formula that will add up any value in column A with a T in the same row on m and subtract that from your 1st check. L7 does the same thing except looking for a value of F.