Spreadsheet: 853407d1703264236-understanding-a-formula-len-silva-vacation-planner
Sheet:  Vacation

 | Vacation Planner
 |  | PLAN START | For the year |  | 2023
ID | NAME |  | START DATE | END DATE | DAYS | WORK DAYS
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238 | 239 | 240 | 241 | 242 | 243 | 244 | 245 | 246 | 247 | 248 | 249 | 250 | 251 | 252 | 253 | 254 | 255 | 256 | 257 | 258 | 259 | 260 | 261 | 262 | 263 | 264 | 265 | 266 | 267 | 268 | 269 | 270 | 271 | 272 | 273 | 274 | 275 | 276 | 277 | 278 | 279 | 280 | 281 | 282 | 283 | 284 | 285 | 286 | 287 | 288 | 289 | 290 | 291 | 292 | 293 | 294 | 295 | 296 | 297 | 298 | 299 | 300 | 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | 309 | 310 | 311 | 312 | 313 | 314 | 315 | 316 | 317 | 318 | 319 | 320 | 321 | 322 | 323 | 324 | 325 | 326 | 327 | 328 | 329 | 330 | 331 | 332 | 333 | 334 | 335 | 336 | 337 | 338 | 339 | 340 | 341 | 342 | 343 | 344 | 345 | 346 | 347 | 348 | 349 | 350 | 351 | 352 | 353 | 354 | 355 | 356 | 357 | 358 | 359 | 360 | 361 | 362 | 363 | 364 | 365 | 366
10101 | NAME 01 |  | 2023-02-01 00:00:00 | 2023-02-05 00:00:00
10102 | NAME 02 |  | 2023-01-07 00:00:00 | 2023-01-20 00:00:00
10103 | NAME 03 |  | 2023-02-08 00:00:00 | 2023-02-15 00:00:00
10104 | [NAME] 04 |  | 2023-03-01 00:00:00 | 2023-03-05 00:00:00
10105 | NAME 05 |  | 2023-01-05 00:00:00 | 2023-01-25 00:00:00
10106 | [NAME] 06 |  | 2023-02-01 00:00:00 | 2023-02-28 00:00:00
10107 | NAME 07 |  | 2023-01-14 00:00:00 | 2023-01-15 00:00:00
10108 | NAME 08 |  | 2023-01-21 00:00:00 | 2023-01-26 00:00:00
 | NAME 09 |  | 2023-01-02 00:00:00 | 2023-01-06 00:00:00
 | NAME 10 |  | 2023-10-15 00:00:00 | 2023-11-15 00:00:00
 | NAME 100 |  | 2023-02-19 00:00:00 | 2023-03-22 00:00:00
 | NAME 101
 | NAME 102
 | NAME 103
 | NAME 104
 | NAME 105
 | NAME 106
 | NAME 107
 | NAME 108
 | [NAME] 109
 | NAME 11
 | NAME 110
 | NAME 111
 | [NAME] 112
 | [NAME] 113
 | NAME 114
 | [NAME] 115
 | NAME 116
 | [NAME] 117
 | NAME 118
 | NAME 119
 | NAME 12
 | NAME 120
 | NAME 121
 | NAME 122
 | NAME 123
 | [NAME] 124
 | NAME 125
 | NAME 126
 | NAME 127
 | NAME 128
 | NAME 129
 | NAME 13
 | NAME 130
 | [NAME] 131
 | NAME 132
 | NAME 133
 | NAME 134
 | NAME 135
 | NAME 136
 | NAME 137
 | [NAME] 138
 | NAME 139
 | NAME 14 |  | 2023-01-21 00:00:00 | 2023-02-04 00:00:00
 | [NAME] 140
 | NAME 141
 | NAME 142
 | NAME 143
 | NAME 144
 | NAME 145
 | NAME 146
 | [NAME] 147
 | NAME 148
 | NAME 149
 | NAME 15
 | NAME 150
 | NAME 151
 | NAME 152
 | NAME 153
 | NAME 154
 | NAME 155
 | NAME 156
 | [NAME] 157
 | NAME 158
 | NAME 159
 | [NAME] 16
 | NAME 160
 | NAME 161
 | NAME 162
 | NAME 163
 | NAME 164
 | NAME 165
 | [NAME] 166
 | NAME 167
 | [NAME] 168
 | NAME 169
 | [NAME] 17
 | NAME 170
 | NAME 171
 | NAME 172
 | NAME 173
 | [NAME] 174
 | NAME 175
 | NAME 176
 | [NAME] 177
 | NAME 178
 | NAME 179
 | NAME 18
 | NAME 180
 | NAME 181
 | NAME 182
 | NAME 183
 | NAME 184
 | NAME 185
 | NAME 186
 | NAME 187
 | [NAME] 188
 | NAME 189
 | NAME 19
 | NAME 190
 | NAME 191
 | [NAME] 192
 | [NAME] 193
 | NAME 194
 | NAME 195
 | [NAME] 196
 | NAME 197
 | [NAME] 198
 | NAME 199
 | NAME 20
 | NAME 200
 | NAME 201
 | NAME 202
 | NAME 203
 | NAME 204
 | NAME 205
 | NAME 206
 | [NAME] 207
 | NAME 208
 | NAME 209
 | NAME 21
 | NAME 210
 | NAME 211
 | NAME 212
 | NAME 213
 | NAME 214
 | [NAME] 215
 | NAME 216
 | NAME 217
 | NAME 218
 | NAME 219
 | NAME 22
 | NAME 220
 | NAME 221
 | NAME 222
 | NAME 223
 | NAME 224
 | NAME 225
 | NAME 226
 | [NAME] 227
 | NAME 228
 | [NAME] 229
 | NAME 23
 | [NAME] 230
 | [NAME] 231
 | [NAME] 232
 | NAME 233
 | NAME 234
 | NAME 235
 | NAME 236
 | NAME 237
 | NAME 238
 | NAME 239
 | NAME 24
 | NAME 240
 | NAME 241
 | NAME 242
 | [NAME] 243
 | [NAME] 244
 | NAME 245
 | NAME 246
 | NAME 247
 | NAME 248
 | NAME 249
 | NAME 25
 | NAME 250
 | [NAME] 251
 | NAME 252
 | NAME 253
 | NAME 254
 | NAME 255
 | NAME 256
 | NAME 257
 | NAME 258
 | NAME 259
 | NAME 26
 | NAME 260
 | NAME 261
 | NAME 262
 | NAME 263
 | NAME 264
 | NAME 265
 | NAME 266
 | NAME 267
 | NAME 268
 | NAME 269
 | NAME 27
 | NAME 270
 | NAME 271
 | NAME 272
 | NAME 273
 | NAME 274
 | NAME 275
 | NAME 276
 | NAME 277
 | NAME 278
 | [NAME] 279
 | NAME 28
 | [NAME] 280
 | NAME 281
 | NAME 282
 | NAME 283
 | NAME 284
 | NAME 285
 | NAME 286
 | [NAME] 287
 | NAME 288
 | NAME 289
 | NAME 29
 | NAME 290
 | NAME 291
 | NAME 292
 | NAME 293
 | NAME 294
 | NAME 295
 | NAME 296
 | NAME 297
 | NAME 298
 | NAME 299
 | NAME 30
 | NAME 300
 | [NAME] 301
 | [NAME] 302
 | NAME 303
 | NAME 304
 | NAME 305
 | NAME 306
 | NAME 307
 | NAME 308
 | NAME 309
 | NAME 31
 | NAME 310
 | NAME 311
 | NAME 312
 | NAME 313
 | NAME 314
 | NAME 315
 | NAME 316
 | NAME 317
 | NAME 318
 | [NAME] 319
 | NAME 32
 | NAME 320
 | [NAME] 321
 | NAME 322
 | NAME 323
 | NAME 324
 | NAME 325
 | NAME 326
 | [NAME] 327
 | [NAME] 328
 | NAME 329
 | NAME 33
 | NAME 330
 | NAME 331
 | [NAME] 332
 | NAME 333
 | [NAME] 334
 | NAME 335
 | NAME 336
 | NAME 337
 | NAME 338
 | NAME 339
 | NAME 34
 | NAME 340
 | NAME 35
 | NAME 36
 | NAME 37
 | NAME 38
 | NAME 39
 | [NAME] 40
 | NAME 41
 | [NAME] 42
 | NAME 43
 | NAME 44
 | NAME 45
 | NAME 46
 | NAME 47
 | NAME 48
 | NAME 49
 | [NAME] 50
 | [NAME] 51
 | NAME 52
 | NAME 53
 | NAME 54
 | NAME 55
 | [NAME] 56
 | [NAME] 57
 | NAME 58
 | NAME 59
 | NAME 60
 | NAME 61
 | [NAME] 62
 | NAME 63
 | NAME 64
 | NAME 65
 | NAME 66
 | [NAME] 67
 | NAME 68
 | NAME 69
 | NAME 70
 | [NAME] 71
 | NAME 72
 | [NAME] 73
 | NAME 74
 | NAME 75
 | NAME 76
 | NAME 77
 | NAME 78
 | NAME 79
 | NAME 80
 | NAME 81
 | NAME 82
 | NAME 83
 | NAME 84
 | NAME 85
 | NAME 86
 | NAME 87
 | [NAME] 88
 | NAME 89
 | NAME 90
 | NAME 91
 | NAME 92
 | NAME 93
 | NAME 94
 | NAME 95
 | NAME 96
 | NAME 97
 | NAME 98
 | NAME 99