Budget and Projecting

[Sykotik7S]

Hi everyone!

So, I have a created a budget spreadsheet detailing the day of the month a bill is due (Example, Rent is due on the 1st rather than a specific date). My goal is to create a section within the spreadsheet or in a separate sheet where I can put in a date range and Excel will pull and display the bills that are due within that date range and how much each expense is. My problem is that I know very basic formulas and I'm not even sure where to begin in figuring this out. So here I am seeking out some help!

Any and all help and advice would be greatly appreciated! Thank you in advance!

 

[mtnblue]

Hi *Sykotik7S,

Here's at least a partial solution for you.
Create a lookup table for your date ranges on a new tab called Period.
The tab where your bills are listed is called Bills.

Period_1 - formula in Column named Period
=CONCATENATE(A2," - ",B2)

Period_2 - formula in Column named End Date
=LOOKUP(F2,$A$2:$A$7,$B$2:$B$7)

Period_2 - formula in Column named Period
=LOOKUP(G2,$B$2:$B$7,$C$2:$C$7)


Bills - formula in Column named Period
=LOOKUP(B2,Period!$F$2:$F$32,Period!$H$2:$H$32)

You could then sort or filter this list to see what bills are due by Period.

Period_1

Period_2

Bills