Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 335
- Office Version
- 365
- Platform
- Windows
Hello,
I have two tables. The two columns that are in question are below. I am trying to count how many dates in Table 2 [In Service Date] that come before the "Accident Date". The actual data is 43000 rows.
I tried something like this, but it didn't work.
=COUNTIFS(Table2[In Service Date],<[@[Accident Date]])
I have two tables. The two columns that are in question are below. I am trying to count how many dates in Table 2 [In Service Date] that come before the "Accident Date". The actual data is 43000 rows.
| Data.xlsx | |||
|---|---|---|---|
| B | |||
| 1 | Accident Date | ||
| 2 | 28-01-2025 | ||
| 3 | 24-01-2025 | ||
| 4 | 09-01-2025 | ||
| 5 | 08-01-2025 | ||
| 6 | 08-01-2025 | ||
| 7 | 29-12-2024 | ||
| 8 | 11-12-2024 | ||
| 9 | 27-11-2024 | ||
| 10 | 27-11-2024 | ||
| 11 | 25-11-2024 | ||
| 12 | 20-11-2024 | ||
Accidents Detail | |||
| Data.xlsx | |||
|---|---|---|---|
| M | |||
| 1 | In Service Date | ||
| 2 | 01-12-1958 | ||
| 3 | 19-12-1958 | ||
| 4 | 15-08-1958 | ||
| 5 | 30-09-1958 | ||
| 6 | 17-10-1958 | ||
| 7 | 23-10-1958 | ||
| 8 | 28-08-1959 | ||
| 9 | 19-07-1959 | ||
| 10 | 22-08-1959 | ||
| 11 | 01-09-1959 | ||
| 12 | 22-09-1959 | ||
| 13 | 02-10-1959 | ||
| 14 | 06-10-1959 | ||
| 15 | 20-10-1959 | ||
| 16 | 29-10-1959 | ||
| 17 | 27-10-1959 | ||
| 18 | 08-12-1959 | ||
| 19 | 13-12-1959 | ||
| 20 | 13-01-1960 | ||
| 21 | 28-01-1960 | ||
| 22 | 06-03-1960 | ||
| 23 | 26-04-1960 | ||
| 24 | 28-04-1960 | ||
| 25 | 19-04-1959 | ||
| 26 | 28-05-1959 | ||
| 27 | 16-07-1959 | ||
| 28 | 10-08-1959 | ||
| 29 | 21-10-1959 | ||
| 30 | 12-12-1959 | ||
| 31 | 22-12-1959 | ||
| 32 | 29-01-1960 | ||
| 33 | 19-03-1960 | ||
| 34 | 24-03-1960 | ||
| 35 | 13-05-1960 | ||
| 36 | 23-06-1960 | ||
| 37 | 11-07-1960 | ||
| 38 | 29-07-1960 | ||
| 39 | 04-12-1959 | ||
| 40 | 14-01-1960 | ||
| 41 | 12-02-1960 | ||
| 42 | 09-04-1960 | ||
| 43 | 08-06-1960 | ||
| 44 | 16-03-1959 | ||
| 45 | 04-05-1959 | ||
| 46 | 31-12-1958 | ||
| 47 | 23-01-1959 | ||
| 48 | 31-01-1959 | ||
| 49 | 13-02-1959 | ||
| 50 | 27-02-1959 | ||
| 51 | 27-03-1959 | ||
| 52 | 09-04-1959 | ||
| 53 | 23-04-1959 | ||
| 54 | 12-05-1959 | ||
| 55 | 21-05-1959 | ||
| 56 | 28-05-1959 | ||
| 57 | 05-06-1959 | ||
| 58 | 19-06-1959 | ||
| 59 | 29-06-1959 | ||
| 60 | 27-07-1959 | ||
| 61 | 31-07-1959 | ||
| 62 | 22-08-1959 | ||
| 63 | 12-08-1959 | ||
| 64 | 15-09-1959 | ||
| 65 | 05-10-1959 | ||
| 66 | 14-10-1959 | ||
| 67 | 29-10-1959 | ||
| 68 | 20-11-1959 | ||
| 69 | 08-07-1959 | ||
| 70 | 17-03-1959 | ||
| 71 | 30-03-1959 | ||
| 72 | 03-04-1959 | ||
| 73 | 18-04-1959 | ||
| 74 | 29-04-1959 | ||
| 75 | 10-05-1959 | ||
| 76 | 13-05-1959 | ||
| 77 | 28-05-1959 | ||
| 78 | 24-05-1959 | ||
| 79 | 13-06-1959 | ||
| 80 | 01-07-1959 | ||
| 81 | 10-07-1959 | ||
| 82 | 14-07-1959 | ||
| 83 | 01-08-1959 | ||
| 84 | 10-11-1959 | ||
| 85 | 05-11-1959 | ||
| 86 | 10-11-1959 | ||
| 87 | 25-11-1959 | ||
| 88 | 15-12-1959 | ||
| 89 | 23-12-1959 | ||
| 90 | 18-01-1960 | ||
| 91 | 30-12-1959 | ||
| 92 | 01-04-1960 | ||
| 93 | 05-04-1960 | ||
| 94 | 22-03-1960 | ||
| 95 | 14-04-1960 | ||
| 96 | 09-05-1960 | ||
| 97 | 29-04-1960 | ||
| 98 | 25-05-1960 | ||
| 99 | 01-07-1960 | ||
| 100 | 09-06-1960 | ||
| 101 | 01-07-1960 | ||
| 102 | 11-06-1959 | ||
| 103 | 03-12-1959 | ||
| 104 | 15-01-1960 | ||
| 105 | 21-01-1960 | ||
| 106 | 10-02-1960 | ||
All Boeing Aircraft | |||
I tried something like this, but it didn't work.
=COUNTIFS(Table2[In Service Date],<[@[Accident Date]])
