Spreadsheet: 169531d1342921745-how-to-write-formula-to-count-part-of-text-test
Sheet: Sheet2

2012-07-21 00:00:00 | [NAME] | Sat | 04 05 16 21 22 28 29 33 37 38 | 5005135
 |  |  | 41 43 44 49 52 54 56 57 59 61 |  |  | 0
2012-07-20 00:00:00 | EVENING | Fri | 02 08 11 17 22 24 25 32 35 36 | 2619945
 |  |  | 38 39 41 48 50 61 62 63 64 67
2012-07-20 00:00:00 | [NAME] | Fri | 05 08 10 14 15 18 19 21 27 29 | 2883474
 |  |  | 31 49 52 53 58 60 64 66 69 70
2012-07-19 00:00:00 | EVENING | Thu | 02 05 07 11 12 15 33 34 37 38 | 1241139
 |  |  | 44 46 47 53 55 57 59 62 64 67
2012-07-19 00:00:00 | [NAME] | Thu | 04 08 09 13 15 16 18 29 31 43 | 6018579
 |  |  | 46 51 54 55 60 62 64 67 68 70
2012-07-18 00:00:00 | EVENING | Wed | 01 02 08 09 14 27 28 29 31 34 | 731965
 |  |  | 35 36 38 42 45 47 56 57 67 70
2012-07-18 00:00:00 | [NAME] | Wed | 02 09 15 17 22 23 25 26 29 35 | 5981658
 |  |  | 38 41 42 47 48 50 59 62 63 69
2012-07-17 00:00:00 | EVENING | Tue | 07 11 15 16 20 23 25 30 31 33 | 9421798
 |  |  | 34 38 39 43 44 48 55 56 63 70
2012-07-17 00:00:00 | [NAME] | Tue | 03 06 08 12 14 21 23 34 35 37 | 6558343
 |  |  | 40 41 48 51 54 55 59 60 66 68
2012-07-16 00:00:00 | EVENING | Mon | 02 04 11 16 19 24 26 42 47 48 | 8414654
 |  |  | 49 50 52 57 58 59 61 63 66 67
2012-07-16 00:00:00 | [NAME] | Mon | 05 07 12 13 16 17 18 32 33 34 | 7274691
 |  |  | 39 41 42 49 53 54 57 60 64 70
2012-07-15 00:00:00 | EVENING | Sun | 07 09 11 12 13 15 20 21 30 38 | 9709462
 |  |  | 43 45 48 53 55 61 64 65 66 68
2012-07-15 00:00:00 | [NAME] | Sun | 01 05 09 10 16 20 23 28 30 31 | 8259689
 |  |  | 33 41 42 53 55 60 61 63 65 70
2012-07-14 00:00:00 | EVENING | Sat | 01 03 06 08 11 19 26 29 30 34 | 197583
 |  |  | 38 40 42 43 44 47 60 65 67 70
2012-07-14 00:00:00 | [NAME] | Sat | 01 03 04 09 11 12 14 16 18 21 | 5450525
 |  |  | 22 35 36 45 47 51 53 58 65 70
2012-07-13 00:00:00 | EVENING | Fri | 12 17 18 24 32 34 35 40 42 43 | 2969750
 |  |  | 45 48 49 50 52 55 60 62 63 65
2012-07-13 00:00:00 | [NAME] | Fri | 07 08 10 12 13 14 15 18 20 25 | 1018892
 |  |  | 33 43 44 45 48 51 52 53 60 62
2012-07-12 00:00:00 | EVENING | Thu | 02 09 12 17 18 19 21 25 33 35 | 4986504
 |  |  | 37 42 46 47 59 62 66 67 69 70
2012-07-12 00:00:00 | [NAME] | Thu | 04 06 09 11 14 27 28 39 44 45 | 239773
 |  |  | 48 52 55 60 61 65 66 67 69 70
2012-07-11 00:00:00 | EVENING | Wed | 02 06 16 17 19 24 28 33 34 35 | 5984873
 |  |  | 37 39 41 44 47 50 53 58 63 70
2012-07-11 00:00:00 | [NAME] | Wed | 02 11 12 18 19 23 25 27 31 32 | 2147078
 |  |  | 47 52 54 56 57 60 62 63 64 67
2012-07-10 00:00:00 | EVENING | Tue | 03 04 16 21 22 23 24 25 26 27 | 741837
 |  |  | 29 32 36 42 43 46 50 51 60 65
2012-07-10 00:00:00 | [NAME] | Tue | 08 09 10 13 16 17 21 25 27 29 | 8620312
 |  |  | 30 35 36 43 52 54 56 58 62 65
2012-07-09 00:00:00 | EVENING | Mon | 02 05 07 16 22 25 28 30 36 37 | 5114975
 |  |  | 38 45 46 47 48 49 51 56 57 59
2012-07-09 00:00:00 | [NAME] | Mon | 01 07 12 13 17 19 22 31 36 39 | 3332389
 |  |  | 40 44 47 48 52 54 55 60 64 69
2012-07-08 00:00:00 | EVENING | Sun | 01 06 08 10 14 18 21 24 27 32 | 8625297
 |  |  | 33 35 37 38 45 52 58 60 64 65
2012-07-08 00:00:00 | [NAME] | Sun | 01 03 09 10 15 20 30 31 32 33 | 9912045
 |  |  | 35 39 44 47 50 53 56 63 65 70
2012-07-07 00:00:00 | EVENING | Sat | 07 10 11 13 17 24 27 30 31 36 | 3667558
 |  |  | 37 47 49 54 55 56 62 63 66 68
2012-07-07 00:00:00 | [NAME] | Sat | 06 07 09 10 16 18 26 27 31 33 | 2661540
 |  |  | 34 35 46 47 48 51 52 60 66 68
2012-07-06 00:00:00 | EVENING | Fri | 04 05 17 18 23 25 33 39 45 46 | 5542222
 |  |  | 47 49 50 52 55 61 62 63 67 70
2012-07-06 00:00:00 | [NAME] | Fri | 01 04 06 07 09 12 14 16 18 21 | 6595780
 |  |  | 30 36 38 41 45 47 50 60 63 64
2012-07-05 00:00:00 | EVENING | Thu | 02 03 05 11 13 18 30 36 41 42 | 8053458
 |  |  | 47 48 51 52 56 61 63 64 67 70
2012-07-05 00:00:00 | [NAME] | Thu | 05 08 16 18 20 23 27 30 35 36 | 5069625
 |  |  | 38 39 46 50 54 56 60 66 68 70
2012-07-04 00:00:00 | EVENING | Wed | 02 04 05 08 09 10 12 13 17 19 | 8182296
 |  |  | 36 38 40 41 46 50 51 54 57 69
2012-07-04 00:00:00 | [NAME] | Wed | 03 05 06 07 11 13 15 16 20 21 | 520972
 |  |  | 24 25 31 49 53 56 59 65 67 69
2012-07-03 00:00:00 | EVENING | Tue | 01 03 07 09 10 11 13 18 22 36 | 7600406
 |  |  | 44 45 47 49 53 56 57 63 69 70
2012-07-03 00:00:00 | [NAME] | Tue | 09 13 14 17 21 25 27 28 29 31 | 8236169
 |  |  | 32 36 43 46 50 53 54 56 60 63
2012-07-02 00:00:00 | EVENING | Mon | 03 06 07 10 11 14 15 27 31 36 | 9865236
 |  |  | 43 44 48 51 57 58 59 61 63 69
2012-07-02 00:00:00 | [NAME] | Mon | 02 04 10 14 16 22 24 26 28 32 | 1361601
 |  |  | 35 41 45 48 53 57 60 66 67 68
2012-07-01 00:00:00 | EVENING | Sun | 02 07 09 15 16 23 24 25 28 34 | 3697065
 |  |  | 36 40 44 47 50 55 56 60 62 65
2012-07-01 00:00:00 | [NAME] | Sun | 02 05 14 19 20 24 28 30 31 33 | 5242206
 |  |  | 37 40 41 44 47 52 54 64 68 70