willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 929
- Office Version
- 365
- Platform
- Windows
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!
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() |