Add up bills in date range using only the day
I have a spreadsheet for my budget that calculates the bills I need to pay each week and I can't figure out how to set up an equation to automatically pull the amount from a list of bills based on what day they are due. Here is how I have it set up. In column "A" I have the date of every Friday (payday) set up as mm/dd/yyyy. The date column covers the entire year. Then in column "B" I have the total of the bills to be paid that week (this is where I want the equation). I have a few other columns that pull from column B but those aren't necessary for this explanation. Over to the right in starting in column "N" I have the day of the month that the bill is due, (e.g. 1st, 5th, 23rd) listed as a single number (1,5,23), in column "O" I have the amount of the bill and in the next column it says what the bill is. How do I set up an equation to pull the amount of the bill if the day falls between Friday of the current week and the day before the following Friday? I have tried using sumif but I can't get it to work.