Spreadsheet: 805617d1668791437-countifs-formulae-that-increase-date-range-via-autofill-paste-example-for-countifs-query
Sheet: Randomisation log

RANDOMISATION LOG |  |  |  |  |  |  | 4m [NAME] |  |  |  | 9m FU |  |  |  |  |  |  |  |  | 12m KIT call |  |  | 15m [NAME] call |  |  | 18m KIT call |  |  | 21m [NAME] call |  |  | 24m [NAME]
N | DATE | MONTH | MONTH (number) | YEAR |  | DATE | DUE | ACTUAL | FULL OR PARTIAL | IF NO, REASON | DUE | ACTUAL | FULL OR PARTIAL | IF NO, REASON | ESM | IF NO, REASON | fMRI | SWITCHED? | IF NO, REASON | DUE | ACTUAL | IF NO, REASON | DUE | ACTUAL | IF NO, REASON | DUE | ACTUAL | IF NO, REASON | DUE | ACTUAL | IF NO, REASON | DUE | ACTUAL | IF NO, REASON
1 | 25 | November |  | 2020 | 2020-11-25 00:00:00
2 | 25 | November |  | 2020 | 2020-11-25 00:00:00 |  |  |  | Full |  |  |  | Full |  | N/A |  | N/A
3 | 27 | November |  | 2020 | 2020-11-27 00:00:00
4 | 27 | November |  | 2020 | 2020-11-27 00:00:00
5 | 30 | November |  | 2020 | 2020-11-30 00:00:00
6 | 1 | December |  | 2020 | 2020-12-01 00:00:00
7 | 1 | December |  | 2020 | 2020-12-01 00:00:00
8 | 3 | December |  | 2020 | 2020-12-03 00:00:00
9 | 9 | December |  | 2020 | 2020-12-09 00:00:00
10 | 10 | December |  | 2020 | 2020-12-10 00:00:00
11 | 14 | December |  | 2020 | 2020-12-14 00:00:00
12 | 14 | December |  | 2020 | 2020-12-14 00:00:00
13 | 15 | December |  | 2020 | 2020-12-15 00:00:00
14 | 15 | December |  | 2020 | 2020-12-15 00:00:00
15 | 16 | December |  | 2020 | 2020-12-16 00:00:00
16 | 17 | December |  | 2020 | 2020-12-17 00:00:00
17 | 18 | December |  | 2020 | 2020-12-18 00:00:00
18 | 7 | January |  | 2021 | TAU
19 | 18 | January |  | 2021 | TF-CBTp
20 | 19 | January |  | 2021
21 | 26 | January |  | 2021
22 | 26 | January |  | 2021
23 | 28 | January |  | 2021
24 | 29 | January |  | 2021
25 | 3 | February |  | 2021
26 | 4 | February |  | 2021
27 | 4 | February |  | 2021
28 | 4 | February |  | 2021
29 | 8 | February |  | 2021
30 | 9 | February |  | 2021
31 | 9 | February |  | 2021
32 | 10 | February |  | 2021
33 | 10 | February |  | 2021
34 | 15 | February |  | 2021
35 | 15 | February |  | 2021
36 | 15 | February |  | 2021
37 | 16 | February |  | 2021
38 | 17 | February |  | 2021
39 | 17 | February |  | 2021
40 | 19 | February |  | 2021
41 | 22 | February |  | 2021
42 | 22 | February |  | 2021
43 | 25 | February |  | 2021
44 | 26 | February |  | 2021
45 | 2 | March |  | 2021
46 | 3 | March |  | 2021
47 | 5 | March |  | 2021
48 | 9 | March |  | 2021
49 | 15 | March |  | 2021
50 | 16 | March |  | 2021
51 | 19 | March |  | 2021
52 | 22 | March |  | 2021
53 | 22 | March |  | 2021
54 | 23 | March |  | 2021
55 | 31 | March |  | 2021
56 | 31 | March |  | 2021
57 | 31 | March |  | 2021
58 | 6 | April |  | 2021
59 | 6 | April |  | 2021
60 | 9 | April |  | 2021
61 | 13 | April |  | 2021
62 | 13 | April |  | 2021
63 | 15 | April |  | 2021
64 | 16 | April |  | 2021
65 | 23 | April |  | 2021
66 | 23 | April |  | 2021
67 | 23 | April |  | 2021
68 | 27 | April |  | 2021
69 | 28 | April |  | 2021
70 | 5 | May |  | 2021
71 | 5 | May |  | 2021
72 | 7 | May |  | 2021
73 | 20 | May |  | 2021
74 | 20 | May |  | 2021
75 | 20 | May |  | 2021
76 | 20 | May |  | 2021
77 | 20 | May |  | 2021
78 | 1 | June |  | 2021
79 | 7 | June |  | 2021
80 | 9 | June |  | 2021
81 | 10 | June |  | 2021
82 | 18 | June |  | 2021
83 | 24 | June |  | 2021
84 | 25 | June |  | 2021
85 | 30 | June |  | 2021
86 | 30 | June |  | 2021
87 | 30 | June |  | 2021
88 | 30 | June |  | 2021
89 | 5 | July |  | 2021
90 | 6 | July |  | 2021
91 | 8 | July |  | 2021
92 | 19 | July |  | 2021
93 | 19 | July |  | 2021
94 | 20 | July |  | 2021
95 | 21 | July |  | 2021
96 | 29 | July |  | 2021
97 | 6 | August |  | 2021
98 | 6 | August |  | 2021
99 | 11 | August |  | 2021
100 | 16 | August |  | 2021
101 | 18 | August |  | 2021
102 | 18 | August |  | 2021
103 | 24 | August |  | 2021
104 | 24 | August |  | 2021
105 | 25 | August |  | 2021
106 | 27 | August |  | 2021
107 | 1 | September |  | 2021
108 | 2 | September |  | 2021
109 | 8 | September |  | 2021
110 | 8 | September |  | 2021
111 | 9 | September |  | 2021
112 | 21 | September |  | 2021
113 | 4 | October |  | 2021
114 | 12 | October |  | 2021
115 | 13 | October |  | 2021
116 | 20 | October |  | 2021
117 | 21 | October |  | 2021
118 | 22 | October |  | 2021
119 | 22 | October |  | 2021
120 | 28 | October |  | 2021
121 | 28 | October |  | 2021
122 | 28 | October |  | 2021
123 | 29 | October |  | 2021
124 | 5 | November |  | 2021
125 | 11 | November |  | 2021
126 | 16 | November |  | 2021
127 | 16 | November |  | 2021
128 | 17 | November |  | 2021
129 | 22 | November |  | 2021
130 | 24 | November |  | 2021
131 | 30 | November |  | 2021
132 | 3 | December |  | 2021
133 | 8 | December |  | 2021
134 | 8 | December |  | 2021
135 | 13 | December |  | 2021
136 | 16 | December |  | 2021
137 | 16 | December |  | 2021
138 | 20 | December |  | 2021
139 | 21 | December |  | 2021
140 | 21 | December |  | 2021
141 | 22 | December |  | 2021
142 | 22 | December |  | 2021
143 | 29 | December |  | 2021
144 | 5 | January |  | 2022
145 | 5 | January |  | 2022
146 | 10 | January |  | 2022
147 | 10 | January |  | 2022
148 | 12 | January |  | 2022
149 | 12 | January |  | 2022
150 | 18 | January |  | 2022
151 | 20 | January |  | 2022
152 | 21 | January |  | 2022
153 | 26 | January |  | 2022
154 | 27 | January |  | 2022
155 | 27 | January |  | 2022
156 | 28 | January |  | 2022
157 | 31 | January |  | 2022
158 | 7 | February |  | 2022
159 | 8 | February |  | 2022
160 | 9 | February |  | 2022
161 | 10 | February |  | 2022
162 | 11 | February |  | 2022
163 | 15 | February |  | 2022
164 | 18 | February |  | 2022
165 | 18 | February |  | 2022
166 | 18 | February |  | 2022
167 | 21 | February |  | 2022
168 | 22 | February |  | 2022
169 | 22 | February |  | 2022
170 | 24 | February |  | 2022
171 | 25 | February |  | 2022
172 | 25 | February |  | 2022
173 | 25 | February |  | 2022
174 | 25 | February |  | 2022
175 | 28 | February |  | 2022
176 | 4 | March |  | 2022
177 | 8 | March |  | 2022
178 | 8 | March |  | 2022
179 | 16 | March |  | 2022
180 | 17 | March |  | 2022
181 | 21 | March |  | 2022
182 | 24 | March |  | 2022
183 | 29 | March |  | 2022
184 | 29 | March |  | 2022
185 | 31 | March |  | 2022
186 | 5 | April |  | 2022
187 | 5 | April |  | 2022
188 | 5 | April |  | 2022
189 | 5 | April |  | 2022
190 | 7 | April |  | 2022
191 | 12 | April |  | 2022
192 | 12 | April |  | 2022
193 | 14 | April |  | 2022
194 | 25 | April |  | 2022
195 | 26 | April |  | 2022
196 | 27 | April |  | 2022
197 | 3 | May |  | 2022
198 | 6 | May |  | 2022
199 | 11 | May |  | 2022
200 | 24 | May |  | 2022
201 | 26 | May |  | 2022
202 | 8 | June |  | 2022
203 | 8 | June |  | 2022
204 | 9 | June |  | 2022
205 | 10 | June |  | 2022
206 | 21 | June |  | 2022
207 | 22 | June |  | 2022
208 | 23 | June |  | 2022
209 | 24 | June |  | 2022
210 | 27 | June |  | 2022
211 | 28 | June |  | 2022
212 | 29 | June |  | 2022
213 | 30 | June |  | 2022
214 | 1 | July |  | 2022
215 | 14 | July |  | 2022
216 | 18 | July |  | 2022
217 | 20 | July |  | 2022
218 | 25 | July |  | 2022
219 | 25 | July |  | 2022
220 | 29 | July |  | 2022
221 | 29 | July |  | 2022
222 | 11 | August |  | 2022
223 | 11 | August |  | 2022
224 | 15 | August |  | 2022
225 | 19 | August |  | 2022
226 | 23 | August |  | 2022
227 | 23 | August |  | 2022
228 | 25 | August |  | 2022
229 | 26 | August |  | 2022
230 | 26 | August |  | 2022
231 | 30 | August |  | 2022
232 | 30 | August |  | 2022
233 | 31 | August |  | 2022
234 | 2 | September |  | 2022
235 | 6 | September |  | 2022
236 | 8 | September |  | 2022
237 | 8 | September |  | 2022
238 | 12 | September |  | 2022
239 | 12 | September |  | 2022
240 | 13 | September |  | 2022
241 | 14 | September |  | 2022
242 | 15 | September |  | 2022
243 | 16 | September |  | 2022
244 | 22 | September |  | 2022
245 | 22 | September |  | 2022
246 | 23 | September |  | 2022
247 | 26 | September |  | 2022
248 | 27 | September |  | 2022
249 | 27 | September |  | 2022
250 | 27 | September |  | 2022
251 | 29 | September |  | 2022
252 | 4 | October |  | 2022
253 | 6 | October |  | 2022
254 | 12 | October |  | 2022
255 | 13 | October |  | 2022
256 | 13 | October |  | 2022
257 | 14 | October |  | 2022
258 | 18 | October |  | 2022
259 | 19 | October |  | 2022
260 | 24 | October |  | 2022
261 | 24 | October |  | 2022
262 | 24 | October |  | 2022
263 | 1 | November |  | 2022
264 | 4 | November |  | 2022
265 | 7 | November |  | 2022
266 | 9 | November |  | 2022