Count the most recent x number of dates that meet certain criteria

[willow1985]

I need help with a formula that counts the most recent 25 items closed.
The result I am looking for is a TRUE/FALSE in column F (Last 25 Closed)
The criteria is based on todays date (H1), Date Closed (Column B), and whether there is a "Yes" in Member of Group (Column G)

Thank you to anyone who can help with this!

Book1
	A	B	C	D	E	F	G	H
1	Date Opened	Date Closed	On Time	Week Number Closed	Days to Completion	Last 25 Closed	Member of Group	2023-02-27
2	25-Aug-21	1-Feb-23	Y	5	376	TRUE	Yes
3	1-Jun-22		N			FALSE	No
4	6-Dec-21	31-Jan-23	N	5	302	FALSE	No
5	12-Jul-22		N			FALSE	Yes
6	28-Mar-22	4-Apr-22	N	14	6	FALSE	Yes
7	1-Apr-22	24-Aug-22	N	34	104	FALSE	Yes
8	18-Apr-22	27-Jun-22	N	26	51	FALSE	Yes
9	4-Apr-22	24-Nov-22	N	47	169	FALSE	Yes
10	21-Apr-22	24-Nov-22	N	47	156	FALSE	Yes
11	3-May-22	23-Nov-22	N	47	147	FALSE	Yes
12	9-May-22	24-Nov-22	N	47	144	FALSE	Yes
13	11-May-22	23-Nov-22	N	47	141	FALSE	Yes
14	17-May-22	16-Nov-22	N	46	132	FALSE	Yes
15	17-May-22	24-Aug-22	N	34	72	FALSE	Yes
16	17-May-22	24-Aug-22	N	34	72	FALSE	Yes
17	28-Jul-22	24-Aug-22	N	34	20	FALSE	Yes
18	10-Aug-22	24-Aug-22	N	34	11	FALSE	Yes
19	26-Aug-22	29-Aug-22	N	35	2	FALSE	Yes
20	6-Sep-22	16-Jan-23	N	3	95	FALSE	Yes
21	26-Sep-22	12-Oct-22	N	41	13	FALSE	Yes
22	27-Sep-22	2-Dec-22	N	48	49	FALSE	Yes
23	11-Oct-22	17-Oct-22	N	42	5	FALSE	Yes
24	24-Oct-22	31-Oct-22	N	44	6	FALSE	No
25	25-Oct-22	23-Nov-22	N	47	22	FALSE	No
26	28-Oct-22	20-Jan-23	N	3	61	TRUE	Yes
27	8-Nov-22	2-Dec-22	N	48	19	FALSE	No
28	10-Nov-22	2-Dec-22	N	48	17	FALSE	Yes
29	15-Nov-22	2-Dec-22	N	48	14	FALSE	Yes
30	21-Nov-22	29-Nov-22	N	48	7	FALSE	Yes
31	21-Nov-22	29-Nov-22	N	48	7	FALSE	Yes
32	2-Dec-22	29-Dec-22	N	52	20	FALSE	Yes
33	6-Dec-22	16-Jan-23	N	3	30	FALSE	No
34	8-Dec-22	16-Jan-23	N	3	28	FALSE	Yes
35	13-Dec-22	16-Jan-23	N	3	25	FALSE	Yes
36	16-Dec-22	16-Jan-23	N	3	22	FALSE	No
37	20-Dec-22	20-Jan-23	N	3	24	TRUE	Yes
38	9-Jan-23	9-Feb-23	N	6	24	TRUE	Yes
39	9-Jan-23		N			FALSE	No
40	9-Jan-23	12-Jan-23	N	2	4	FALSE	No
41	13-Jan-23	16-Jan-23	N	3	2	FALSE	Yes
42	11-Jan-23	16-Jan-23	N	3	4	FALSE	Yes
43	11-Jan-23	12-Jan-23	N	2	2	FALSE	No
44	12-Jan-23	23-Feb-23	N	8	31	TRUE	Yes
45	12-Jan-23	16-Jan-23	N	3	3	FALSE	No
46	13-Jan-23	19-Jan-23	N	3	5	TRUE	Yes
47	23-Jan-23	27-Jan-23	N	4	5	TRUE	Yes
48	23-Jan-23		N			FALSE	No
49	23-Jan-23	27-Jan-23	N	4	5	TRUE	Yes
50	23-Jan-23	30-Jan-23	N	5	6	TRUE	Yes
51	23-Jan-23	30-Jan-23	N	5	6	TRUE	Yes
52	23-Jan-23	8-Feb-23	N	6	13	TRUE	Yes
53	25-Jan-23	8-Feb-23	N	6	11	TRUE	Yes
54	27-Jan-23	2-Feb-23	N	5	5	TRUE	Yes
55	27-Jan-23	15-Feb-23	N	7	14	TRUE	Yes
56	27-Jan-23	27-Jan-23	N	4	1	TRUE	Yes
57	27-Jan-23	27-Jan-23	N	4	1	TRUE	Yes
58	27-Jan-23	3-Feb-23	N	5	6	TRUE	Yes
59	31-Jan-23	21-Feb-23	Y	8	16	TRUE	Yes
60	3-Feb-23	7-Feb-23	Y	6	3	TRUE	Yes
61	9-Feb-23					FALSE	Yes
62	10-Feb-23	14-Feb-23	Y	7	3	TRUE	Yes
63	10-Feb-23	21-Feb-23	Y	8	8	TRUE	Yes
64	10-Feb-23					FALSE	No
65	10-Feb-23	13-Feb-23	Y	7	2	TRUE	Yes
66	14-Feb-23	15-Feb-23	Y	7	2	TRUE	Yes
67	23-Feb-23	24-Feb-23	Y	8	2	TRUE	Yes
68	23-Feb-23					FALSE	Yes
69	24-Feb-23					FALSE	Yes
70	24-Feb-23	27-Feb-23	Y	9	2	TRUE	Yes
Sheet1

Cell Formulas
Range	Formula
H1	H1	=TODAY()

 

[Fluff]

How about

=AND(G2="Yes",B2>=AGGREGATE(14,6,$B$2:$B$70/($G$2:$G$70="yes"),25))

 

[willow1985]

How about

=AND(G2="Yes",B2>=AGGREGATE(14,6,$B$2:$B$70/($G$2:$G$70="yes"),25))

Works perfect! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.