List of items within a specific month

[dmj120]

I'm trying to get a dynamic list based on a selected month and year. Any ideas?

Annual Budget __ Sep-Aug (moving).xlsx
	A	B	C	D	E
1		Month Total	15000	1	mon
2				2025	yr
3		Pay Date	Amount
4		8/30/2024	5000
5		9/13/2024	5000
6		9/27/2024	5000
7		10/11/2024	5000
8		10/25/2024	5000
9		11/8/2024	5000
10		11/22/2024	5000
11		12/6/2024	5000
12		12/20/2024	5000
13		1/3/2025	5000
14		1/17/2025	5000
15		1/31/2025	5000
16		2/14/2025	5000
17		2/28/2025	5000
18		3/14/2025	5000
19		3/28/2025	5000
20		4/11/2025	5000
21		4/25/2025	5000
22		5/9/2025	5000
23		5/23/2025	5000
24		6/6/2025	5000
25		6/20/2025	5000
26		7/4/2025	5000
27		7/18/2025	5000
28		8/1/2025	5000
29		8/15/2025	5000
30		8/29/2025	5000
31		9/12/2025	5000
32
Sheet3

Cell Formulas
Range	Formula
C1	C1	=SUMIFS(C3:C31, B3:B31, ">=" & DATE(D2, D1, 1), B3:B31, "<=" & EOMONTH(DATE(D2, D1, 1), 0))
B5:B31	B5	=B4+14
E3:E31	E3	=IFERROR(INDEX($B$3:$B$31, SMALL(IF((MONTH($B$3:$B$31)=$D$1)*(YEAR($B$3:$B$31)=$D$2), ROW($B$3:$B$31)-ROW($B$3)+1), ROW(3:3))), "")

 

[dmj120]

Tried Filter() but I must not be doing something correctly

FILTER(B4:B31, (B4:B31=MONTH(D1))*(B4:B31=YEAR(D2)))

 

[Fluff]

How about

=FILTER(B4:B31,(B4:B31>=DATE(D2,D1,1))*(B4:B31<DATE(D2,D1+1,1)))

 

[dmj120]

How about

=FILTER(B4:B31,(B4:B31>=DATE(D2,D1,1))*(B4:B31<DATE(D2,D1+1,1)))

Wow.... talk about over thinking. Thanks!!!

 

[Fluff]

You're welcome & thanks for the feedback.