Spreadsheet: 45344d1244101169-formula-not-updating-cells-accordingly-connectzone-sales-barometer
Sheet: Connectzone Card Sales

 | SALES BAROMETER - Connectzone
 |  | Line : |  | Connectzone Card Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | Orange | Green
 |  | Yearly Target |  | 40000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | min | 168 | 167 | 166
 |  | Achieved |  | 13802 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 167 | 166
 |  | Remaining |  | 26198 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y Values | Between 168 and 0 | Between 167 and 167 | Between 166 and 166
 |  | Original Daily Target |  | 166.6666666666667 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181 | 181 | #N/A | #N/A
 |  | Working days |  | 160
 |  | New Daily Target |  | 181
 |  | Days remaining | Month | Day | Achieved
 |  |  | 2009-01-09 00:00:00 |  | 3346
 |  |  | 2009-02-09 00:00:00 |  | 3811
 |  |  | 2009-03-09 00:00:00 |  | 3557
 |  |  | 2009-04-09 00:00:00 |  | 2023
 |  | 160 | 2009-05-04 00:00:00 | Monday | 157
 |  | 159 | 2009-05-05 00:00:00 | Tuesday | 85
 |  | 158 | 2009-05-06 00:00:00 | Wednesday | 83
 |  | 157 | 2009-05-07 00:00:00 | Thursday | 65
 |  | 156 | 2009-05-08 00:00:00 | Friday | 57
 |  | 155 | 2009-05-11 00:00:00 | Monday | 5
 |  | 154 | 2009-05-12 00:00:00 | Tuesday | 68
 |  | 153 | 2009-05-13 00:00:00 | Wednesday | 73
 |  | 152 | 2009-05-14 00:00:00 | Thursday | 67
 |  | 151 | 2009-05-15 00:00:00 | Friday | 69
 |  | 150 | 2009-05-18 00:00:00 | Monday | 87
 |  | 149 | 2009-05-19 00:00:00 | Tuesday | 68
 |  | 148 | 2009-05-20 00:00:00 | Wednesday | 56
 |  | 147 | 2009-05-21 00:00:00 | Thursday | 30
 |  | 146 | 2009-05-22 00:00:00 | Friday | 13
 |  | 145 | 2009-05-25 00:00:00 | Monday | 82
 |  | 144 | 2009-05-26 00:00:00 | Tuesday
 |  | 143 | 2009-05-27 00:00:00 | Wednesday
 |  | 142 | 2009-05-28 00:00:00 | Thursday
 |  | 141 | 2009-05-29 00:00:00 | Friday
 |  | 140 | 2009-06-01 00:00:00 | Monday
 |  | 139 | 2009-06-02 00:00:00 | Tuesday
 |  | 138 | 2009-06-03 00:00:00 | Wednesday
 |  | 137 | 2009-06-04 00:00:00 | Thursday
 |  | 136 | 2009-06-05 00:00:00 | Friday
 |  | 135 | 2009-06-08 00:00:00 | Monday
 |  | 134 | 2009-06-09 00:00:00 | Tuesday
 |  | 133 | 2009-06-10 00:00:00 | Wednesday
 |  | 132 | 2009-06-11 00:00:00 | Thursday
 |  | 131 | 2009-06-12 00:00:00 | Friday
 |  | 130 | 2009-06-15 00:00:00 | Monday
 |  | 129 | 2009-06-17 00:00:00 | Wednesday
 |  | 128 | 2009-06-18 00:00:00 | Thursday
 |  | 127 | 2009-06-19 00:00:00 | Friday
 |  | 126 | 2009-06-22 00:00:00 | Monday
 |  | 125 | 2009-06-23 00:00:00 | Tuesday
 |  | 124 | 2009-06-24 00:00:00 | Wednesday
 |  | 123 | 2009-06-25 00:00:00 | Thursday
 |  | 122 | 2009-06-26 00:00:00 | Friday
 |  | 121 | 2009-06-29 00:00:00 | Monday
 |  | 120 | 2009-06-30 00:00:00 | Tuesday
 |  | 119 | 2009-07-01 00:00:00 | Wednesday
 |  | 118 | 2009-07-02 00:00:00 | Thursday
 |  | 117 | 2009-07-03 00:00:00 | Friday
 |  | 116 | 2009-07-06 00:00:00 | Monday
 |  | 115 | 2009-07-07 00:00:00 | Tuesday
 |  | 114 | 2009-07-08 00:00:00 | Wednesday
 |  | 113 | 2009-07-09 00:00:00 | Thursday
 |  | 112 | 2009-07-10 00:00:00 | Friday
 |  | 111 | 2009-07-13 00:00:00 | Monday
 |  | 110 | 2009-07-14 00:00:00 | Tuesday
 |  | 109 | 2009-07-15 00:00:00 | Wednesday
 |  | 108 | 2009-07-16 00:00:00 | Thursday
 |  | 107 | 2009-07-17 00:00:00 | Friday
 |  | 106 | 2009-07-20 00:00:00 | Monday
 |  | 105 | 2009-07-21 00:00:00 | Tuesday
 |  | 104 | 2009-07-22 00:00:00 | Wednesday
 |  | 103 | 2009-07-23 00:00:00 | Thursday
 |  | 102 | 2009-07-24 00:00:00 | Friday
 |  | 101 | 2009-07-27 00:00:00 | Monday
 |  | 100 | 2009-07-28 00:00:00 | Tuesday
 |  | 99 | 2009-07-29 00:00:00 | Wednesday
 |  | 98 | 2009-07-30 00:00:00 | Thursday
 |  | 97 | 2009-07-31 00:00:00 | Friday
 |  | 96 | 2009-08-03 00:00:00 | Monday
 |  | 95 | 2009-08-04 00:00:00 | Tuesday
 |  | 94 | 2009-08-05 00:00:00 | Wednesday
 |  | 93 | 2009-08-06 00:00:00 | Thursday
 |  | 92 | 2009-08-07 00:00:00 | Friday
 |  | 91 | 2009-08-10 00:00:00 | Monday
 |  | 90 | 2009-08-11 00:00:00 | Tuesday
 |  | 89 | 2009-08-12 00:00:00 | Wednesday
 |  | 88 | 2009-08-13 00:00:00 | Thursday
 |  | 87 | 2009-08-14 00:00:00 | Friday
 |  | 86 | 2009-08-17 00:00:00 | Monday
 |  | 85 | 2009-08-18 00:00:00 | Tuesday
 |  | 84 | 2009-08-19 00:00:00 | Wednesday
 |  | 83 | 2009-08-20 00:00:00 | Thursday
 |  | 82 | 2009-08-21 00:00:00 | Friday
 |  | 81 | 2009-08-24 00:00:00 | Monday
 |  | 80 | 2009-08-25 00:00:00 | Tuesday
 |  | 79 | 2009-08-26 00:00:00 | Wednesday
 |  | 78 | 2009-08-27 00:00:00 | Thursday
 |  | 77 | 2009-08-28 00:00:00 | Friday
 |  | 76 | 2009-08-31 00:00:00 | Monday
 |  | 75 | 2009-09-01 00:00:00 | Tuesday
 |  | 74 | 2009-09-02 00:00:00 | Wednesday
 |  | 73 | 2009-09-03 00:00:00 | Thursday
 |  | 72 | 2009-09-04 00:00:00 | Friday
 |  | 71 | 2009-09-07 00:00:00 | Monday
 |  | 70 | 2009-09-08 00:00:00 | Tuesday
 |  | 69 | 2009-09-09 00:00:00 | Wednesday
 |  | 68 | 2009-09-10 00:00:00 | Thursday
 |  | 67 | 2009-09-11 00:00:00 | Friday
 |  | 66 | 2009-09-14 00:00:00 | Monday
 |  | 65 | 2009-09-15 00:00:00 | Tuesday
 |  | 64 | 2009-09-16 00:00:00 | Wednesday
 |  | 63 | 2009-09-17 00:00:00 | Thursday
 |  | 62 | 2009-09-18 00:00:00 | Friday
 |  | 61 | 2009-09-21 00:00:00 | Monday
 |  | 60 | 2009-09-22 00:00:00 | Tuesday
 |  | 59 | 2009-09-23 00:00:00 | Wednesday
 |  | 58 | 2009-09-25 00:00:00 | Friday
 |  | 57 | 2009-09-28 00:00:00 | Monday
 |  | 56 | 2009-09-29 00:00:00 | Tuesday
 |  | 55 | 2009-09-30 00:00:00 | Wednesday
 |  | 54 | 2009-10-01 00:00:00 | Thursday
 |  | 53 | 2009-10-02 00:00:00 | Friday
 |  | 52 | 2009-10-05 00:00:00 | Monday
 |  | 51 | 2009-10-06 00:00:00 | Tuesday
 |  | 50 | 2009-10-07 00:00:00 | Wednesday
 |  | 49 | 2009-10-08 00:00:00 | Thursday
 |  | 48 | 2009-10-09 00:00:00 | Friday
 |  | 47 | 2009-10-12 00:00:00 | Monday
 |  | 46 | 2009-10-13 00:00:00 | Tuesday
 |  | 45 | 2009-10-14 00:00:00 | Wednesday
 |  | 44 | 2009-10-15 00:00:00 | Thursday
 |  | 43 | 2009-10-16 00:00:00 | Friday
 |  | 42 | 2009-10-19 00:00:00 | Monday
 |  | 41 | 2009-10-20 00:00:00 | Tuesday
 |  | 40 | 2009-10-21 00:00:00 | Wednesday
 |  | 39 | 2009-10-22 00:00:00 | Thursday
 |  | 38 | 2009-10-23 00:00:00 | Friday
 |  | 37 | 2009-10-26 00:00:00 | Monday
 |  | 36 | 2009-10-27 00:00:00 | Tuesday
 |  | 35 | 2009-10-28 00:00:00 | Wednesday
 |  | 34 | 2009-10-29 00:00:00 | Thursday
 |  | 33 | 2009-10-30 00:00:00 | Friday
 |  | 32 | 2009-11-02 00:00:00 | Monday
 |  | 31 | 2009-11-03 00:00:00 | Tuesday
 |  | 30 | 2009-11-04 00:00:00 | Wednesday
 |  | 29 | 2009-11-05 00:00:00 | Thursday
 |  | 28 | 2009-11-06 00:00:00 | Friday
 |  | 27 | 2009-11-09 00:00:00 | Monday
 |  | 26 | 2009-11-10 00:00:00 | Tuesday
 |  | 25 | 2009-11-11 00:00:00 | Wednesday
 |  | 24 | 2009-11-12 00:00:00 | Thursday
 |  | 23 | 2009-11-13 00:00:00 | Friday
 |  | 22 | 2009-11-16 00:00:00 | Monday
 |  | 21 | 2009-11-17 00:00:00 | Tuesday
 |  | 20 | 2009-11-18 00:00:00 | Wednesday
 |  | 19 | 2009-11-19 00:00:00 | Thursday
 |  | 18 | 2009-11-20 00:00:00 | Friday
 |  | 17 | 2009-11-23 00:00:00 | Monday
 |  | 16 | 2009-11-24 00:00:00 | Tuesday
 |  | 15 | 2009-11-25 00:00:00 | Wednesday
 |  | 14 | 2009-11-26 00:00:00 | Thursday
 |  | 13 | 2009-11-27 00:00:00 | Friday
 |  | 12 | 2009-11-30 00:00:00 | Monday
 |  | 11 | 2009-12-01 00:00:00 | Tuesday
 |  | 10 | 2009-12-02 00:00:00 | Wednesday
 |  | 9 | 2009-12-03 00:00:00 | Thursday
 |  | 8 | 2009-12-04 00:00:00 | Friday
 |  | 7 | 2009-12-07 00:00:00 | Monday
 |  | 6 | 2009-12-08 00:00:00 | Tuesday
 |  | 5 | 2009-12-09 00:00:00 | Wednesday
 |  | 4 | 2009-12-10 00:00:00 | Thursday
 |  | 3 | 2009-12-11 00:00:00 | Friday
 |  | 2 | 2009-12-14 00:00:00 | Monday
 |  | 1 | 2009-12-15 00:00:00 | Tuesday