Spreadsheet: 121965d1316528891-excel-calendar-finding-closest-date-and-then-matching-text-project-calender-and-dates-
Sheet: Project calendar

 |  | Date | Day
 |  | Date | Day
 | 2011-11-01 00:00:00 | WK1 |  | Task 1 Project 1
 |  | WK2
 |  | WK3
 |  | WK4
 |  | WK5
 |  | WK6
 |  | WK7
 |  | WK8 |  | Task 2 Project 1
 |  | WK9
 |  | WK10
 |  | WK11
 |  | WK12
 |  | WK13
 |  | WK14
 |  | WK15
 |  | WK16
 |  | WK17
 |  | WK18
 |  | WK19
 |  | WK20
 |  | WK21
 |  | WK22
 |  | WK23
 |  | WK24
 |  | WK25
 |  | WK26
 |  | [NAME]
 |  | WK28
 |  | WK29
 |  | WK30
 |  | WK31
 |  | WK32
 |  | WK33
 |  | WK34
 |  | WK35
 |  | WK36
 |  | WK37
 |  | WK38
 |  | WK39
 |  | WK40
 |  | WK41
 |  | WK42
 |  | WK43
 |  | WK44
 |  | WK45
 |  | WK46
 |  | WK47
 |  | WK48
 |  | WK49
 |  | WK50
 |  | WK51
 |  | WK52
 |  | WK1
 |  | WK2
 |  | WK3
 |  | WK4
 |  | WK5
 |  | WK6
 |  | WK7
 |  | WK8
 |  | WK9
 |  | WK10
 |  | WK11
 |  | WK12
 |  | WK13
 |  | WK14
 |  | WK15
 |  | WK16
 |  | WK17
 |  | WK18
 |  | WK19
 |  | WK20
 |  | WK21
 |  | WK22
 |  | WK23
 |  | WK24
 |  | WK25
 |  | WK26
 |  | [NAME]
 |  | WK28
 |  | WK29
 |  | WK30
 |  | WK31
 |  | WK32
 |  | WK33
 |  | WK34
 |  | WK35
 |  | WK36
 |  | WK37
 |  | WK38
 |  | WK39
 |  | WK40
 |  | WK41
 |  | WK42
 |  | WK43
 |  | WK44
 |  | WK45
 |  | WK46
 |  | WK47
 |  | WK48
 |  | WK49
 |  | WK50
 |  | WK51
 |  | WK52
 |  | WK1
 |  | WK2
 |  | WK3
 |  | WK4
 |  | WK5
 |  | WK6
 |  | WK7
 |  | WK8
 |  | WK9
 |  | WK10
 |  | WK11
 |  | WK12
 |  | WK13
 |  | WK14
 |  | WK15
 |  | WK16
 |  | WK17
 |  | WK18
 |  | WK19
 |  | WK20
 |  | WK21
 |  | WK22
 |  | WK23
 |  | WK24
 |  | WK25
 |  | WK26
 |  | [NAME]
 |  | WK28
 |  | WK29
 |  | WK30
 |  | WK31
 |  | WK32
 |  | WK33
 |  | WK34
 |  | WK35
 |  | WK36
 |  | WK37
 |  | WK38
 |  | WK39
 |  | WK40
 |  | WK41
 |  | WK42
 |  | WK43
 |  | WK44
 |  | WK45
 |  | WK46
 |  | WK47
 |  | WK48
 |  | WK49
 |  | WK50
 |  | WK51
 |  | WK52
 |  | WK1
 |  | WK2
 |  | WK3
 |  | WK4
 |  | WK5
 |  | WK6
 |  | WK7
 |  | WK8
 |  | WK9
 |  | WK10
 |  | WK11
 |  | WK12
 |  | WK13
 |  | WK14
 |  | WK15
 |  | WK16
 |  | WK17
 |  | WK18
 |  | WK19
 |  | WK20
 |  | WK21
 |  | WK22
 |  | WK23
 |  | WK24
 |  | WK25
 |  | WK26
 |  | [NAME]
 |  | WK28
 |  | WK29
 |  | WK30
 |  | WK31
 |  | WK32
 |  | WK33
 |  | WK34
 |  | WK35
 |  | WK36
 |  | WK37
 |  | WK38
 |  | WK39
 |  | WK40
 |  | WK41
 |  | WK42
 |  | WK43
 |  | WK44
 |  | WK45
 |  | WK46
 |  | WK47
 |  | WK48
 |  | WK49
 |  | WK50
 |  | WK51
 |  | WK52
 |  | WK1
 |  | WK2
 |  | WK3
 |  | WK4
 |  | WK5
 |  | WK6
 |  | WK7
 |  | WK8
 |  | WK9
 |  | WK10
 |  | WK11
 |  | WK12
 |  | WK13
 |  | WK14
 |  | WK15
 |  | WK16
 |  | WK17
 |  | WK18
 |  | WK19
 |  | WK20
 |  | WK21
 |  | WK22
 |  | WK23
 |  | WK24
 |  | WK25
 |  | WK26
 |  | [NAME]
 |  | WK28
 |  | WK29
 |  | WK30
 |  | WK31
 |  | WK32
 |  | WK33
 |  | WK34
 |  | WK35
 |  | WK36
 |  | WK37
 |  | WK38
 |  | WK39
 |  | WK40
 |  | WK41
 |  | WK42
 |  | WK43
 |  | WK44
 |  | WK45
 |  | WK46
 |  | WK47
 |  | WK48
 |  | WK49
 |  | WK50
 |  | WK51
 |  | WK52
 |  | WK53
 |  | WK54
 |  | WK55
 |  | WK56
 |  | WK57
 |  | WK58
 |  | WK59
 |  | WK60
 |  | WK61
 |  | WK62
 |  | WK63
 |  | WK64
 |  | WK65
 |  | WK66
 |  | WK67
 |  | WK68
 |  | WK69
 |  | WK70
 |  | WK71
 |  | WK72
 |  | WK73
 |  | WK74
 |  | [NAME]
 |  | WK76
 |  | WK77
 |  | WK78
 |  | WK79
 |  | WK80
 |  | WK81
 |  | WK82
 |  | WK83
 |  | WK84
 |  | WK85
 |  | WK86
 |  | WK87
 |  | WK88
 |  | WK89
 |  | WK90
 |  | WK91
 |  | WK92
 |  | WK93
 |  | WK94
 |  | WK95
 |  | WK96
 |  | WK97
 |  | WK98
 |  | WK99
 |  | WK100
 |  | WK101
 |  | WK102
 |  | WK103
 |  | WK104
 |  | WK105
 |  | WK106
 |  | WK107
 |  | WK108
 |  | WK109
 |  | [NAME]
 |  | WK111
 |  | [NAME]
 |  | WK113
 |  | WK114
 |  | [NAME]
 |  | WK116
 |  | WK117
 |  | [NAME]
 |  | WK119
 |  | WK120
 |  | WK121
 |  | WK122
 |  | WK123
 |  | [NAME]
 |  | WK125
 |  | WK126
 |  | [NAME]
 |  | WK128
 |  | [NAME]
 |  | WK130
 |  | WK131
 |  | [NAME]
 |  | WK133
 |  | WK134
 |  | WK135
 |  | WK136
 |  | WK137
 |  | [NAME]
 |  | WK139
 |  | WK140
 |  | WK141
 |  | WK142
 |  | WK143
 |  | WK144
 |  | WK145
 |  | WK146
 |  | WK147
 |  | WK148
 |  | [NAME]
 |  | WK150
 |  | WK151
 |  | WK152
 |  | WK153
 |  | WK154
 |  | [NAME]
 |  | WK156
 |  | [NAME]
 |  | WK158
 |  | [NAME]
 |  | WK160
 |  | WK161
 |  | WK162
 |  | WK163
 |  | WK164
 |  | WK165
 |  | WK166
 |  | WK167
 |  | WK168
 |  | WK169
 |  | [NAME]
 |  | WK171
 |  | [NAME]
 |  | [NAME]
 |  | WK174
 |  | WK175
 |  | WK176
 |  | WK177
 |  | WK178
 |  | WK179
 |  | WK180
 |  | WK181
 |  | WK182
 |  | WK183
 |  | [NAME]
 |  | WK185
 |  | WK186
 |  | WK187
 |  | WK188
 |  | [NAME]
 |  | WK190
 |  | [NAME]
 |  | [NAME]
 |  | WK193
 |  | WK194
 |  | WK195
 |  | [NAME]
 |  | WK197
 |  | WK198
 |  | WK199
 |  | WK200
 |  | WK201
 |  | WK202
 |  | WK203
 |  | WK204
 |  | WK205
 |  | WK206
 |  | WK207
 |  | WK208
 |  | WK209
 |  | WK210
 |  | WK211
 |  | WK212
 |  | WK213
 |  | WK214
 |  | WK215
 |  | WK216
 |  | WK217
 |  | WK218
 |  | WK219
 |  | WK220
 |  | WK221
 |  | WK222
 |  | WK223
 |  | WK224
 |  | WK225
 |  | WK226
 |  | [NAME]
 |  | WK228
 |  | [NAME]
 |  | WK230
 |  | WK231
 |  | WK232
 |  | WK233
 |  | WK234
 |  | WK235
 |  | [NAME]
 |  | WK237
 |  | WK238
 |  | [NAME]
 |  | WK240
 |  | WK241
 |  | WK242
 |  | WK243
 |  | WK244
 |  | WK245
 |  | [NAME]
 |  | WK247
 |  | WK248
 |  | WK249
 |  | WK250
 |  | [NAME]
 |  | WK252
 |  | WK253
 |  | WK254
 |  | WK255
 |  | WK256
 |  | WK257
 |  | [NAME]
 |  | WK259
 |  | WK260
 |  | WK261
 |  | WK262
 |  | WK263
 |  | WK264
 |  | WK265
 |  | WK266
 |  | WK267
 |  | WK268
 |  | WK269
 |  | WK270
 |  | WK271
 |  | [NAME]
 |  | WK273
 |  | WK274
 |  | WK275
 |  | WK276
 |  | WK277
 |  | WK278
 |  | WK279
 |  | WK280
 |  | WK281
 |  | WK282
 |  | WK283
 |  | WK284
 |  | WK285
 |  | WK286
 |  | [NAME]
 |  | WK288
 |  | WK289
 |  | WK290
 |  | WK291
 |  | WK292
 |  | WK293
 |  | WK294
 |  | WK295
 |  | WK296
 |  | WK297
 |  | WK298
 |  | WK299
 |  | WK300
 |  | WK301
 |  | [NAME]
 |  | WK303
 |  | WK304
 |  | WK305
 |  | WK306
 |  | WK307
 |  | [NAME]
 |  | [NAME]
 |  | WK310
 |  | WK311
 |  | WK312
 |  | WK313
 |  | WK314
 |  | WK315
 |  | WK316
 |  | WK317
 |  | WK318
 |  | WK319
 |  | WK320
 |  | [NAME]
 |  | WK322
 |  | WK323
 |  | WK324
 |  | WK325
 |  | WK326
 |  | WK327
 |  | [NAME]
 |  | [NAME]
 |  | WK330
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | WK334
 |  | WK335
 |  | WK336
 |  | WK337
 |  | WK338
 |  | WK339
 |  | [NAME]
 |  | WK341
 |  | WK342
 |  | WK343
 |  | WK344
 |  | WK345
 |  | WK346
 |  | WK347
 |  | WK348
 |  | WK349
 |  | WK350
 |  | WK351
 |  | WK352
 |  | WK353
 |  | WK354
 |  | WK355
 |  | WK356
 |  | WK357
 |  | WK358
 |  | [NAME]
 |  | WK360
 |  | WK361
 |  | WK362
 |  | WK363
 |  | WK364
 |  | WK365
 |  | [NAME]
 |  | WK367
 |  | WK368
 |  | WK369
 |  | WK370
 |  | WK371
 |  | WK372
 |  | [NAME]
 |  | WK374
 |  | WK375
 |  | WK376
 |  | WK377
 |  | WK378
 |  | WK379
 |  | WK380
 |  | WK381
 |  | WK382
 |  | WK383
 |  | WK384
 |  | [NAME]
 |  | WK386
 |  | WK387
 |  | WK388
 |  | WK389
 |  | [NAME]
 |  | WK391
 |  | WK392
 |  | WK393
 |  | WK394
 |  | [NAME]
 |  | WK396
 |  | WK397
 |  | WK398
 |  | WK399
 |  | WK400
 |  | [NAME]
 |  | WK402
 |  | WK403
 |  | WK404
 |  | WK405
 |  | WK406
 |  | WK407
 |  | WK408
 |  | WK409
 |  | WK410
 |  | WK411
 |  | WK412
 |  | WK413
 |  | WK414
 |  | WK415
 |  | WK416
 |  | WK417
 |  | WK418
 |  | WK419
 |  | WK420
 |  | WK421
 |  | WK422
 |  | WK423
 |  | [NAME]
 |  | WK425
 |  | WK426
 |  | WK427
 |  | WK428
 |  | WK429
 |  | WK430
 |  | WK431
 |  | WK432
 |  | WK433
 |  | WK434
 |  | WK435
 |  | WK436
 |  | WK437
 |  | WK438
 |  | WK439
 |  | WK440
 |  | WK441
 |  | WK442
 |  | WK443
 |  | WK444
 |  | WK445
 |  | WK446
 |  | WK447
 |  | WK448
 |  | [NAME]
 |  | WK450
 |  | WK451
 |  | WK452
 |  | WK453
 |  | WK454
 |  | WK455
 |  | WK456
 |  | WK457
 |  | WK458
 |  | WK459
 |  | WK460
 |  | WK461
 |  | WK462
 |  | WK463
 |  | WK464
 |  | WK465
 |  | [NAME]
 |  | [NAME]
 |  | WK468
 |  | WK469
 |  | [NAME]
 |  | WK471
 |  | WK472
 |  | WK473
 |  | WK474
 |  | [NAME]
 |  | WK476
 |  | WK477
 |  | [NAME]
 |  | WK479
 |  | [NAME]
 |  | WK481
 |  | [NAME]
 |  | WK483
 |  | WK484
 |  | WK485
 |  | WK486
 |  | WK487
 |  | WK488
 |  | WK489
 |  | WK490
 |  | WK491
 |  | [NAME]
 |  | WK493
 |  | WK494
 |  | WK495
 |  | WK496
 |  | WK497
 |  | [NAME]
 |  | WK499
 |  | WK500
 |  | WK501
 |  | [NAME]
 |  | [NAME]
 |  | WK504
 |  | WK505
 |  | WK506
 |  | WK507
 |  | WK508
 |  | WK509
 |  | WK510
 |  | WK511
 |  | WK512
 |  | WK513
 |  | WK514
 |  | WK515
 |  | WK516
 |  | [NAME]
 |  | WK518
 |  | WK519
 |  | WK520
 |  | WK521
 |  | WK522
 |  | WK523
 |  | WK524
 |  | WK525
 |  | WK526
 |  | WK527
 |  | WK528
 |  | WK529
 |  | [NAME]
 |  | WK531
 |  | WK532
 |  | WK533
 |  | [NAME]
 |  | WK535
 |  | WK536
 |  | [NAME]
 |  | WK538
 |  | WK539
 |  | WK540
 |  | WK541
 |  | WK542
 |  | WK543
 |  | WK544
 |  | WK545
 |  | WK546
 |  | WK547
 |  | [NAME]
 |  | WK549
 |  | WK550
 |  | WK551
 |  | WK552
 |  | WK553
 |  | [NAME]
 |  | WK555
 |  | WK556
 |  | WK557
 |  | WK558
 |  | WK559
 |  | [NAME]
 |  | WK561
 |  | WK562
 |  | WK563
 |  | WK564
 |  | WK565
 |  | WK566
 |  | WK567
 |  | WK568
 |  | WK569
 |  | [NAME]
 |  | WK571
 |  | [NAME]
 |  | WK573
 |  | WK574
 |  | WK575
 |  | [NAME]
 |  | WK577
 |  | WK578
 |  | WK579
 |  | WK580
 |  | WK581
 |  | [NAME]
 |  | WK583
 |  | WK584
 |  | WK585
 |  | WK586
 |  | WK587
 |  | WK588
 |  | WK589
 |  | WK590
 |  | WK591
 |  | WK592
 |  | WK593
 |  | WK594
 |  | WK595
 |  | WK596
 |  | WK597
 |  | WK598
 |  | WK599
 |  | WK600
 |  | WK601
 |  | WK602
 |  | WK603
 |  | WK604
 |  | [NAME]
 |  | WK606
 |  | WK607
 |  | WK608
 |  | [NAME]
 |  | WK610
 |  | WK611
 |  | [NAME]
 |  | WK613
 |  | [NAME]
 |  | WK615
 |  | WK616
 |  | WK617
 |  | WK618
 |  | WK619
 |  | WK620
 |  | WK621
 |  | WK622
 |  | WK623
 |  | WK624
 |  | WK625
 |  | WK626
 |  | WK627
 |  | WK628
 |  | WK629
 |  | WK630
 |  | WK631
 |  | WK632
 |  | WK633
 |  | WK634
 |  | [NAME]
 |  | WK636
 |  | WK637
 |  | WK638
 |  | WK639
 |  | WK640
 |  | WK641
 |  | WK642
 |  | WK643
 |  | WK644
 |  | WK645
 |  | WK646
 |  | WK647
 |  | [NAME]
 |  | WK649
 |  | WK650
 |  | [NAME]
 |  | WK652
 |  | [NAME]
 |  | WK654
 |  | WK655
 |  | WK656
 |  | WK657
 |  | WK658
 |  | WK659
 |  | [NAME]
 |  | WK661
 |  | WK662
 |  | WK663
 |  | WK664
 |  | WK665
 |  | WK666
 |  | WK667
 |  | [NAME]
 |  | WK669
 |  | WK670
 |  | WK671
 |  | WK672
 |  | [NAME]
 |  | WK674
 |  | [NAME]
 |  | WK676
 |  | WK677
 |  | WK678
 |  | WK679
 |  | WK680
 |  | [NAME]
 |  | WK682
 |  | WK683
 |  | WK684
 |  | WK685
 |  | WK686
 |  | WK687
 |  | WK688
 |  | WK689
 |  | WK690
 |  | WK691
 |  | [NAME]
 |  | WK693
 |  | WK694
 |  | WK695
 |  | WK696
 |  | WK697
 |  | WK698
 |  | WK699