Spreadsheet: 794881d1662378259-absence-trackershowing-extra-days-in-some-months-how-to-fix-hslt-absence-tracker
Sheet: Settings

 | List of Employees |  | Type of Leave |  | Other reasons for Leave Of Absence |  | Months |  | yes/no
 | Employee 1 |  | Sickness Absence |  | Degree ceremony/wedding |  | January |  | Yes
 | Employee 2 |  | Dependant Care Paid |  | [NAME] (Parental Bereavement |  | February |  | No
 | Employee 3 |  | Compassionate Paid |  | Fertility |  | March
 | Employee 4 |  | Leave of Absence Paid |  | Maternity/Adoption Support Leave |  | April
 | Employee 5 |  | Leave of Absence Unpaid |  | Interviews |  | May
 | Employee 6 |  | Dependant Care Unpaid |  | Jury Service (Statutory) |  | June
 | Employee 7 |  |  |  | Induction Day |  | July
 | Employee 8 |  |  |  | Medical &amp; Dental Appointments |  | August
 | Employee 9 |  |  |  | International Sport Selection |  | September
 | Employee 10 |  |  |  | Public Duties (Statutory) |  | October
 | Employee 11 |  |  |  | Redundancy (Statutory) |  | November
 | Employee 12 |  |  |  | Reserve Forces |  | December
 | Employee 13 |  |  |  | Study Leave
 | Employee 14 |  |  |  | Weather
 | Employee 15
 | Employee 16
 | Employee 17
 | Employee 18 |  | Reason for sickness |  | Bank Holidays
 | Employee 19 |  | Back / Neck |  | Boxing Day (substitute day) | 2021-12-27 00:00:00
 | Employee 20 |  | Chest & Respiratory |  | Christmas Day (substitute day) | 2021-12-28 00:00:00
 | Employee 21 |  | Ear, [NAME], Throat ect |  | New Year's Day | 2022-01-01 00:00:00
 | Employee 22 |  | Gynaecological |  | New Year's Day (substitute day) | 2022-01-03 00:00:00
 | Employee 23 |  | Heart (Pressure, Circulation etc) |  | Mother's Day | 2022-03-27 00:00:00
 | Employee 24 |  | Infection |  | Good Friday | 2022-04-15 00:00:00
 | Employee 25 |  | Mental Health (Stress / Anxiety etc) |  | Easter Sunday | 2022-04-17 00:00:00
 | Employee 26 |  | [NAME] |  | Easter Monday | 2022-04-18 00:00:00
 | Employee 27 |  | Neurological |  | Early May bank holiday | 2022-05-02 00:00:00
 | Employee 28 |  | Other |  | Spring bank holiday | 2022-05-30 00:00:00
 | Employee 29 |  | Pregnancy Related |  | Boxing Day | 2022-12-26 00:00:00
 | Employee 30 |  | Stomach Related |  | Christmas Day (substitute day) | 2022-12-27 00:00:00
 | Employee 31 |  | Viral |  | New Year's Day (substitute day) | 2023-01-02 00:00:00
 | Employee 32 |  |  |  | Mother's Day | 2023-03-19 00:00:00
 | Employee 33 |  |  |  | Good Friday | 2023-04-07 00:00:00
 | Employee 34 |  |  |  | Easter Sunday | 2023-04-09 00:00:00
 | Employee 35 |  |  |  | Easter Monday | 2023-04-10 00:00:00
 | Employee 36 |  |  |  | Early May bank holiday | 2023-05-01 00:00:00
 | Employee 37 |  |  |  | Spring bank holiday | 2023-05-29 00:00:00
 | Employee 38 |  |  |  | Christmas Day | 2023-12-25 00:00:00
 | Employee 39 |  |  |  | Boxing Day | 2023-12-26 00:00:00
 | Employee 40 |  |  |  | New Year's Day | 2024-01-01 00:00:00
 | Employee 41 |  |  |  | Mother's Day | 2024-03-10 00:00:00
 | Employee 42 |  |  |  | Good Friday | 2024-03-29 00:00:00
 | Employee 43 |  |  |  | Easter Sunday | 2024-03-31 00:00:00
 | Employee 44 |  |  |  | Easter Monday | 2024-04-01 00:00:00
 | Employee 45 |  |  |  | Early May bank holiday | 2024-05-06 00:00:00
 | Employee 46 |  |  |  | Spring bank holiday | 2024-05-27 00:00:00
 | Employee 47 |  |  |  | Christmas Day | 2024-12-25 00:00:00
 | Employee 48 |  |  |  | Boxing Day | 2024-12-26 00:00:00
 | Employee 49
 | Employee 50
 | Employee 51
 | Employee 52
 | Employee 53
 | Employee 54
 | Employee 55
 | Employee 56
 | Employee 57
 | Employee 58
 | Employee 59
 | Employee 60
 | Employee 61
 | Employee 62
 | Employee 63
 | Employee 64
 | Employee 65
 | Employee 66
 | Employee 67
 | Employee 68
 | Employee 69
 | Employee 70
 | Employee 71
 | Employee 72
 | Employee 73
 | Employee 74
 | Employee 75
 | Employee 76
 | Employee 77
 | Employee 78
 | Employee 79
 | Employee 80
 | Employee 81
 | Employee 82
 | Employee 83
 | Employee 84
 | Employee 85
 | Employee 86
 | Employee 87
 | Employee 88
 | Employee 89
 | Employee 90
 | Employee 91
 | Employee 92
 | Employee 93
 | Employee 94
 | Employee 95
 | Employee 96
 | Employee 97
 | Employee 98
 | Employee 99
 | Employee 100
 | Employee 101
 | Employee 102
 | Employee 103
 | Employee 104
 | Employee 105
 | Employee 106
 | Employee 107
 | Employee 108
 | Employee 109
 | Employee 110
 | Employee 111
 | Employee 112
 | Employee 113
 | Employee 114
 | Employee 115
 | Employee 116
 | Employee 117
 | Employee 118
 | Employee 119
 | Employee 120
 | Employee 121
 | Employee 122
 | Employee 123
 | Employee 124
 | Employee 125
 | Employee 126
 | Employee 127
 | Employee 128
 | Employee 129
 | Employee 130
 | Employee 131
 | Employee 132
 | Employee 133
 | Employee 134
 | Employee 135
 | Employee 136
 | Employee 137
 | Employee 138
 | Employee 139
 | Employee 140
 | Employee 141
 | Employee 142
 | Employee 143
 | Employee 144
 | Employee 145
 | Employee 146
 | Employee 147
 | Employee 148
 | Employee 149
 | Employee 150
 | Employee 151
 | Employee 152
 | Employee 153
 | Employee 154
 | Employee 155
 | Employee 156
 | Employee 157
 | Employee 158
 | Employee 159
 | Employee 160
 | Employee 161
 | Employee 162
 | Employee 163
 | Employee 164
 | Employee 165
 | Employee 166
 | Employee 167
 | Employee 168
 | Employee 169
 | Employee 170
 | Employee 171
 | Employee 172
 | Employee 173
 | Employee 174
 | Employee 175
 | Employee 176
 | Employee 177
 | Employee 178
 | Employee 179
 | Employee 180
 | Employee 181
 | Employee 182
 | Employee 183
 | Employee 184
 | Employee 185
 | Employee 186
 | Employee 187
 | Employee 188
 | Employee 189
 | Employee 190
 | Employee 191
 | Employee 192
 | Employee 193
 | Employee 194
 | Employee 195
 | Employee 196
 | Employee 197
 | Employee 198
 | Employee 199
 | Employee 200