2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/BobTheSkull060979
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#spreadsheet
#budget
#bills
#equation
#sumif
#date range
#Friday
#day of the month
#mm/dd/yyyy
#column
#excel
#payday
#week
#amount
#formula
#calculation
#logic
#data
#automation
#pay