Spreadsheet: 813925d1674059791-school-attendance-calculator-school-attendance-calculator
Sheet: Sheet1

 | School attendance calculator
 | https://www.excelforum.com/excel-formulas-and-functions/1397819-school-attendance-calculator.html
 |  |  |  | Current Scenario | [NAME]
 | School days |  | 190
 | Days left |  |  | 187 | 0
 | Days passed
 | % attendance |  |  | 0.1
 | Days attended
 | Day | Days Attended | Days Left | [NAME] | % Attendance
 | 2 | 0 | 188 | 0 | 0
 | 3 | 0 | 187 | 187 | 0.9842105263157894
 | 4 | 0 | 186 | 186 | 0.9789473684210527
 | 5 | 0 | 185 | 185 | 0.9736842105263158
 | 6 | 0 | 184 | 184 | 0.968421052631579
 | 7 | 0 | 183 | 183 | 0.9631578947368421
 | 8 | 0 | 182 | 182 | 0.9578947368421052
 | 9 | 0 | 181 | 181 | 0.9526315789473684
 | 10 | 1 | 180 | 181 | 0.9526315789473684
 | 11 | 1 | 179 | 180 | 0.9473684210526315
 | 12 | 1 | 178 | 179 | 0.9421052631578948
 | 13 | 1 | 177 | 178 | 0.9368421052631579
 | 14 | 1 | 176 | 177 | 0.9315789473684211
 | 15 | 1 | 175 | 176 | 0.9263157894736842
 | 16 | 1 | 174 | 175 | 0.9210526315789473
 | 17 | 1 | 173 | 174 | 0.9157894736842105
 | 18 | 1 | 172 | 173 | 0.9105263157894737
 | 19 | 1 | 171 | 172 | 0.9052631578947369
 | 20 | 2 | 170 | 172 | 0.9052631578947369
 | 21 | 2 | 169 | 171 | 0.9
 | 22 | 2 | 168 | 170 | 0.8947368421052632
 | 23 | 2 | 167 | 169 | 0.8894736842105263
 | 24 | 2 | 166 | 168 | 0.8842105263157894
 | 25 | 2 | 165 | 167 | 0.8789473684210526
 | 26 | 2 | 164 | 166 | 0.8736842105263158
 | 27 | 2 | 163 | 165 | 0.868421052631579
 | 28 | 2 | 162 | 164 | 0.8631578947368421
 | 29 | 2 | 161 | 163 | 0.8578947368421053
 | 30 | 3 | 160 | 163 | 0.8578947368421053
 | 31 | 3 | 159 | 162 | 0.8526315789473684
 | 32 | 3 | 158 | 161 | 0.8473684210526315
 | 33 | 3 | 157 | 160 | 0.8421052631578947
 | 34 | 3 | 156 | 159 | 0.8368421052631579
 | 35 | 3 | 155 | 158 | 0.8315789473684211
 | 36 | 3 | 154 | 157 | 0.8263157894736842
 | 37 | 3 | 153 | 156 | 0.8210526315789474
 | 38 | 3 | 152 | 155 | 0.8157894736842105
 | 39 | 3 | 151 | 154 | 0.8105263157894737
 | 40 | 4 | 150 | 154 | 0.8105263157894737
 | 41 | 4 | 149 | 153 | 0.8052631578947368
 | 42 | 4 | 148 | 152 | 0.8
 | 43 | 4 | 147 | 151 | 0.7947368421052632
 | 44 | 4 | 146 | 150 | 0.7894736842105263
 | 45 | 4 | 145 | 149 | 0.7842105263157895
 | 46 | 4 | 144 | 148 | 0.7789473684210526
 | 47 | 4 | 143 | 147 | 0.7736842105263158
 | 48 | 4 | 142 | 146 | 0.7684210526315789
 | 49 | 4 | 141 | 145 | 0.7631578947368421
 | 50 | 5 | 140 | 145 | 0.7631578947368421
 | 51 | 5 | 139 | 144 | 0.7578947368421053
 | 52 | 5 | 138 | 143 | 0.7526315789473684
 | 53 | 5 | 137 | 142 | 0.7473684210526316
 | 54 | 5 | 136 | 141 | 0.7421052631578947
 | 55 | 5 | 135 | 140 | 0.7368421052631579
 | 56 | 5 | 134 | 139 | 0.7315789473684211
 | 57 | 5 | 133 | 138 | 0.7263157894736842
 | 58 | 5 | 132 | 137 | 0.7210526315789474
 | 59 | 5 | 131 | 136 | 0.7157894736842105
 | 60 | 6 | 130 | 136 | 0.7157894736842105
 | 61 | 6 | 129 | 135 | 0.7105263157894737
 | 62 | 6 | 128 | 134 | 0.7052631578947368
 | 63 | 6 | 127 | 133 | 0.7
 | 64 | 6 | 126 | 132 | 0.6947368421052632
 | 65 | 6 | 125 | 131 | 0.6894736842105263
 | 66 | 6 | 124 | 130 | 0.6842105263157895
 | 67 | 6 | 123 | 129 | 0.6789473684210526
 | 68 | 6 | 122 | 128 | 0.6736842105263158
 | 69 | 6 | 121 | 127 | 0.6684210526315789
 | 70 | 7 | 120 | 127 | 0.6684210526315789
 | 71 | 7 | 119 | 126 | 0.6631578947368421
 | 72 | 7 | 118 | 125 | 0.6578947368421053
 | 73 | 7 | 117 | 124 | 0.6526315789473685
 | 74 | 7 | 116 | 123 | 0.6473684210526316
 | 75 | 7 | 115 | 122 | 0.6421052631578947
 | 76 | 7 | 114 | 121 | 0.6368421052631579
 | 77 | 7 | 113 | 120 | 0.631578947368421
 | 78 | 7 | 112 | 119 | 0.6263157894736842
 | 79 | 7 | 111 | 118 | 0.6210526315789474
 | 80 | 8 | 110 | 118 | 0.6210526315789474
 | 81 | 8 | 109 | 117 | 0.6157894736842106
 | 82 | 8 | 108 | 116 | 0.6105263157894737
 | 83 | 8 | 107 | 115 | 0.6052631578947368
 | 84 | 8 | 106 | 114 | 0.6
 | 85 | 8 | 105 | 113 | 0.5947368421052631
 | 86 | 8 | 104 | 112 | 0.5894736842105263
 | 87 | 8 | 103 | 111 | 0.5842105263157895
 | 88 | 8 | 102 | 110 | 0.5789473684210527
 | 89 | 8 | 101 | 109 | 0.5736842105263158
 | 90 | 9 | 100 | 109 | 0.5736842105263158
 | 91 | 9 | 99 | 108 | 0.5684210526315789
 | 92 | 9 | 98 | 107 | 0.5631578947368421
 | 93 | 9 | 97 | 106 | 0.5578947368421052
 | 94 | 9 | 96 | 105 | 0.5526315789473685
 | 95 | 9 | 95 | 104 | 0.5473684210526316
 | 96 | 9 | 94 | 103 | 0.5421052631578948
 | 97 | 9 | 93 | 102 | 0.5368421052631579
 | 98 | 9 | 92 | 101 | 0.531578947368421
 | 99 | 9 | 91 | 100 | 0.5263157894736842
 | 100 | 10 | 90 | 100 | 0.5263157894736842
 | 101 | 10 | 89 | 99 | 0.5210526315789473
 | 102 | 10 | 88 | 98 | 0.5157894736842106
 | 103 | 10 | 87 | 97 | 0.5105263157894737
 | 104 | 10 | 86 | 96 | 0.5052631578947369
 | 105 | 10 | 85 | 95 | 0.5
 | 106 | 10 | 84 | 94 | 0.4947368421052631
 | 107 | 10 | 83 | 93 | 0.4894736842105263
 | 108 | 10 | 82 | 92 | 0.4842105263157895
 | 109 | 10 | 81 | 91 | 0.4789473684210526
 | 110 | 11 | 80 | 91 | 0.4789473684210526
 | 111 | 11 | 79 | 90 | 0.4736842105263158
 | 112 | 11 | 78 | 89 | 0.468421052631579
 | 113 | 11 | 77 | 88 | 0.4631578947368421
 | 114 | 11 | 76 | 87 | 0.4578947368421052
 | 115 | 11 | 75 | 86 | 0.4526315789473684
 | 116 | 11 | 74 | 85 | 0.4473684210526316
 | 117 | 11 | 73 | 84 | 0.4421052631578947
 | 118 | 11 | 72 | 83 | 0.4368421052631579
 | 119 | 11 | 71 | 82 | 0.4315789473684211
 | 120 | 12 | 70 | 82 | 0.4315789473684211
 | 121 | 12 | 69 | 81 | 0.4263157894736842
 | 122 | 12 | 68 | 80 | 0.4210526315789473
 | 123 | 12 | 67 | 79 | 0.4157894736842105
 | 124 | 12 | 66 | 78 | 0.4105263157894737
 | 125 | 12 | 65 | 77 | 0.4052631578947368
 | 126 | 12 | 64 | 76 | 0.4
 | 127 | 12 | 63 | 75 | 0.3947368421052632
 | 128 | 12 | 62 | 74 | 0.3894736842105263
 | 129 | 12 | 61 | 73 | 0.3842105263157894
 | 130 | 13 | 60 | 73 | 0.3842105263157894
 | 131 | 13 | 59 | 72 | 0.3789473684210526
 | 132 | 13 | 58 | 71 | 0.3736842105263158
 | 133 | 13 | 57 | 70 | 0.3684210526315789
 | 134 | 13 | 56 | 69 | 0.3631578947368421
 | 135 | 13 | 55 | 68 | 0.3578947368421053
 | 136 | 13 | 54 | 67 | 0.3526315789473684
 | 137 | 13 | 53 | 66 | 0.3473684210526316
 | 138 | 13 | 52 | 65 | 0.3421052631578947
 | 139 | 13 | 51 | 64 | 0.3368421052631579
 | 140 | 14 | 50 | 64 | 0.3368421052631579
 | 141 | 14 | 49 | 63 | 0.331578947368421
 | 142 | 14 | 48 | 62 | 0.3263157894736842
 | 143 | 14 | 47 | 61 | 0.3210526315789474
 | 144 | 14 | 46 | 60 | 0.3157894736842105
 | 145 | 14 | 45 | 59 | 0.3105263157894737
 | 146 | 14 | 44 | 58 | 0.3052631578947368
 | 147 | 14 | 43 | 57 | 0.3
 | 148 | 14 | 42 | 56 | 0.2947368421052631
 | 149 | 14 | 41 | 55 | 0.2894736842105263
 | 150 | 15 | 40 | 55 | 0.2894736842105263
 | 151 | 15 | 39 | 54 | 0.2842105263157895
 | 152 | 15 | 38 | 53 | 0.2789473684210526
 | 153 | 15 | 37 | 52 | 0.2736842105263158
 | 154 | 15 | 36 | 51 | 0.2684210526315789
 | 155 | 15 | 35 | 50 | 0.2631578947368421
 | 156 | 15 | 34 | 49 | 0.2578947368421053
 | 157 | 15 | 33 | 48 | 0.2526315789473684
 | 158 | 15 | 32 | 47 | 0.2473684210526316
 | 159 | 15 | 31 | 46 | 0.2421052631578947
 | 160 | 16 | 30 | 46 | 0.2421052631578947
 | 161 | 16 | 29 | 45 | 0.2368421052631579
 | 162 | 16 | 28 | 44 | 0.2315789473684211
 | 163 | 16 | 27 | 43 | 0.2263157894736842
 | 164 | 16 | 26 | 42 | 0.2210526315789474
 | 165 | 16 | 25 | 41 | 0.2157894736842105
 | 166 | 16 | 24 | 40 | 0.2105263157894737
 | 167 | 16 | 23 | 39 | 0.2052631578947368
 | 168 | 16 | 22 | 38 | 0.2
 | 169 | 16 | 21 | 37 | 0.1947368421052632
 | 170 | 17 | 20 | 37 | 0.1947368421052632
 | 171 | 17 | 19 | 36 | 0.1894736842105263
 | 172 | 17 | 18 | 35 | 0.1842105263157895
 | 173 | 17 | 17 | 34 | 0.1789473684210526
 | 174 | 17 | 16 | 33 | 0.1736842105263158
 | 175 | 17 | 15 | 32 | 0.1684210526315789
 | 176 | 17 | 14 | 31 | 0.1631578947368421
 | 177 | 17 | 13 | 30 | 0.1578947368421053
 | 178 | 17 | 12 | 29 | 0.1526315789473684
 | 179 | 17 | 11 | 28 | 0.1473684210526316
 | 180 | 18 | 10 | 28 | 0.1473684210526316
 | 181 | 18 | 9 | 27 | 0.1421052631578947
 | 182 | 18 | 8 | 26 | 0.1368421052631579
 | 183 | 18 | 7 | 25 | 0.131578947368421
 | 184 | 18 | 6 | 24 | 0.1263157894736842
 | 185 | 18 | 5 | 23 | 0.1210526315789474
 | 186 | 18 | 4 | 22 | 0.1157894736842105
 | 187 | 18 | 3 | 21 | 0.1105263157894737
 | 188 | 18 | 2 | 20 | 0.1052631578947368
 | 189 | 18 | 1 | 19 | 0.1
 | 190 | 19 | 0 | 19 | 0.1