Spreadsheet: 853429d1703279012-understanding-a-formula-len-silva-vacation-planner-2
Sheet:  Vacation

 | Vacation Planner
 | PLAN START | For the year |  | 2023
ID | NAME | START DATE | END DATE | DAYS | WORK DAYS
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