Populate Monthly Expenses Based on Date Range

[alansbanans]

Hi all. I've tried to find something similar to this but can't quite solve it.

I'm building a budget and would like to input a date range (pay date to next pay date) and have monthly expenses populate if the due date is within that date range.

On Sheet1 I have a set of values with the day of the amount that expense is due:

	E	F	G
1	Expense	Date	Amount
2	Rent	1	1500

On Sheet2 is the budget for that pay period with a defined pay period.

	A	B
2	Pay Period Start	Pay Period End
3	12	25

Then on the same sheet I have something like this:

	G	F
2	Rent

I would like to populate Sheet2 cell F2 with the rent amount from Sheet1 IF the due date falls within the 12th and 25th.

Thanks in advance!

 

[myall_blues]

Like this perhaps, assuming you don't only want rent figures.

Book1
	D	E	F	G	H
1		Expense	Date	Amount
2		Rent	1	1500
3		Rent 2	15	300
4		Water	11	100
5		Power	20	200
6		Internet	13	60
7
Sheet1

Book1
	A	B	C	D	E	F	G	H	I
1
2	Start	End				Rent 2	15	300
3	12	25				Power	20	200
4						Internet	13	60
5
6
Sheet2

Cell Formulas
Range	Formula
F2:H4	F2	=FILTER(Sheet1!E2:G6,(Sheet1!F2:F6>=A$3)*(Sheet1!F2:F6<=B$3))
Dynamic array formulas.

 

[alansbanans]

That's awesome, thank you so much! I was not trying the filter but that's perfect.

 

[myall_blues]

You’re welcome. Thanks for the feedback.