Spreadsheet: 887088d1737210094-computation-of-leave-days-leave-days-mind-hunt-correct
Sheet: Sheet2

Length of Service | Annual Leave Days | Monthly Leave
1 | 18 |  |  |  |  |  |  |  |  |  |  | (YEARFRAC($E$14,E$14)*12>=3)*MIN($C$2:$C$3)
9 | 21
20 | 30
 |  |  |  |  | Monthly Leave Accrual
Employee Name | Date Joined | Years of Service | Annual Leave Days |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
Empl 1 | 2018-08-10 00:00:00 | 6 | 18 |  | 1.5 | 3 | 4.5 | 6 | 7.5 | 9 | 10.5 | 12 | 13.5 | 15 | 16.5 | 18
Empl 2 | 1999-09-15 00:00:00 | 25 | 21 |  | 1.75 | 3.5 | 5.25 | 7 | 8.75 | 10.5 | 12.25 | 14 | 15.75 | 17.5 | 19.25 | 21
Empl 3 | 2025-01-01 00:00:00 | 0 | 0 |  | 0 | 0 | 0 | 1.5 | 3 | 4.5 | 6 | 7.5 | 9 | 10.5 | 12 | 13.5
 |  |  |  |  | YEAR 1 |  |  |  |  |  |  |  |  |  |  |  | YEAR 2 |  |  |  |  |  |  |  |  |  |  |  | YEAR 3 |  |  |  |  |  |  |  |  |  |  |  | YEAR 4 |  |  |  |  |  |  |  |  |  |  |  | YEAR 5 |  |  |  |  |  |  |  |  |  |  |  | YEAR 6 |  |  |  |  |  |  |  |  |  |  |  | YEAR 7 |  |  |  |  |  |  |  |  |  |  |  | YEAR 8 |  |  |  |  |  |  |  |  |  |  |  | YEAR 9 |  |  |  |  |  |  |  |  |  |  |  | YEAR 10 |  |  |  |  |  |  |  |  |  |  |  | YEAR 11 |  |  |  |  |  |  |  |  |  |  |  | YEAR 12
Employee Name | Date Joined | Years of Service | Annual Leave Days |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00 | 2028-04-01 00:00:00 | 2028-05-01 00:00:00 | 2028-06-01 00:00:00 | 2028-07-01 00:00:00 | 2028-08-01 00:00:00 | 2028-09-01 00:00:00 | 2028-10-01 00:00:00 | 2028-11-01 00:00:00 | 2028-12-01 00:00:00 | 2029-01-01 00:00:00 | 2029-02-01 00:00:00 | 2029-03-01 00:00:00 | 2029-04-01 00:00:00 | 2029-05-01 00:00:00 | 2029-06-01 00:00:00 | 2029-07-01 00:00:00 | 2029-08-01 00:00:00 | 2029-09-01 00:00:00 | 2029-10-01 00:00:00 | 2029-11-01 00:00:00 | 2029-12-01 00:00:00 | 2030-01-01 00:00:00 | 2030-02-01 00:00:00 | 2030-03-01 00:00:00 | 2030-04-01 00:00:00 | 2030-05-01 00:00:00 | 2030-06-01 00:00:00 | 2030-07-01 00:00:00 | 2030-08-01 00:00:00 | 2030-09-01 00:00:00 | 2030-10-01 00:00:00 | 2030-11-01 00:00:00 | 2030-12-01 00:00:00 | 2031-01-01 00:00:00 | 2031-02-01 00:00:00 | 2031-03-01 00:00:00 | 2031-04-01 00:00:00 | 2031-05-01 00:00:00 | 2031-06-01 00:00:00 | 2031-07-01 00:00:00 | 2031-08-01 00:00:00 | 2031-09-01 00:00:00 | 2031-10-01 00:00:00 | 2031-11-01 00:00:00 | 2031-12-01 00:00:00 | 2032-01-01 00:00:00 | 2032-02-01 00:00:00 | 2032-03-01 00:00:00 | 2032-04-01 00:00:00 | 2032-05-01 00:00:00 | 2032-06-01 00:00:00 | 2032-07-01 00:00:00 | 2032-08-01 00:00:00 | 2032-09-01 00:00:00 | 2032-10-01 00:00:00 | 2032-11-01 00:00:00 | 2032-12-01 00:00:00 | 2033-01-01 00:00:00 | 2033-02-01 00:00:00 | 2033-03-01 00:00:00 | 2033-04-01 00:00:00 | 2033-05-01 00:00:00 | 2033-06-01 00:00:00 | 2033-07-01 00:00:00 | 2033-08-01 00:00:00 | 2033-09-01 00:00:00 | 2033-10-01 00:00:00 | 2033-11-01 00:00:00 | 2033-12-01 00:00:00 | 2034-01-01 00:00:00 | 2034-02-01 00:00:00 | 2034-03-01 00:00:00 | 2034-04-01 00:00:00 | 2034-05-01 00:00:00 | 2034-06-01 00:00:00 | 2034-07-01 00:00:00 | 2034-08-01 00:00:00 | 2034-09-01 00:00:00 | 2034-10-01 00:00:00 | 2034-11-01 00:00:00 | 2034-12-01 00:00:00 | 2035-01-01 00:00:00 | 2035-02-01 00:00:00 | 2035-03-01 00:00:00 | 2035-04-01 00:00:00 | 2035-05-01 00:00:00 | 2035-06-01 00:00:00 | 2035-07-01 00:00:00 | 2035-08-01 00:00:00 | 2035-09-01 00:00:00 | 2035-10-01 00:00:00 | 2035-11-01 00:00:00 | 2035-12-01 00:00:00 | 2036-01-01 00:00:00 | 2036-02-01 00:00:00 | 2036-03-01 00:00:00 | 2036-04-01 00:00:00 | 2036-05-01 00:00:00 | 2036-06-01 00:00:00 | 2036-07-01 00:00:00 | 2036-08-01 00:00:00 | 2036-09-01 00:00:00 | 2036-10-01 00:00:00 | 2036-11-01 00:00:00 | 2036-12-01 00:00:00
Empl 1 | 2018-08-10 00:00:00
Empl 2 | 1999-09-15 00:00:00
Empl 3 | 2025-01-01 00:00:00
 | EMPLOYEE 1 |  |  |  |  | EMPLOYEE 2
 | Date Joined | Months in Service | Years of Service | Leave Entitllement |  | Date Joined | Months in Service | Years of Service | Leave Entitllement
 | 2011-07-01 00:00:00 | 168 | 14 | 18 |  | 2024-07-01 00:00:00 | 7 | 0 | 18
Month | Leave Carried Forward | Monthly Leave Days | Leave taken / Commuted | Accumulated Leave days |  | Leave Carried Forward | Monthly Leave Days | Leave taken / Commuted | Accumulated Leave days
2024-07-01 00:00:00 | 0 | 1.5 |  | 1.5 |  | 0 | 0
2024-08-01 00:00:00 | 1.5 | 1.5 |  | 3 |  |  | 0
2024-09-01 00:00:00 | 3 | 1.5 |  | 4.5 |  | 3 | 0
2024-10-01 00:00:00 | 4.5 | 1.5 |  | 6 |  | 4.5 | 1
2024-11-01 00:00:00 | 6 | 1.5 |  | 7.5 |  | 6 | 1
2024-12-01 00:00:00 | 7.5 | 1.5 |  | 9 |  | 7.5 | 1
2025-01-01 00:00:00 | 9 | 1.5 |  | 10.5 |  | 9 | 1
2025-02-01 00:00:00 | 10.5 | 1.5 |  | 12 |  | 10.5 | 1
2025-03-01 00:00:00 | 12 | 1.5 |  | 13.5 |  | 12 | 1
2025-04-01 00:00:00 | 13.5 | 1.5 |  | 15 |  | 13.5 | 1
2025-05-01 00:00:00 | 15 | 1.5 |  | 16.5 |  | 15 | 1
2025-06-01 00:00:00 | 16.5 | 1.5 |  | 18 |  | 16.5 | 1
2025-07-01 00:00:00 | 18 | 1.5 |  | 19.5 |  | 18 | 1
2025-08-01 00:00:00 | 19.5 | 1.5 |  | 21 |  | 19.5 | 1
2025-09-01 00:00:00 | 21 | 1.5 |  | 22.5 |  | 21 | 1
2025-10-01 00:00:00 | 22.5 | 1.5 |  | 24 |  | 22.5 | 1
2025-11-01 00:00:00 | 24 | 1.5 |  | 25.5 |  | 24 | 1
2025-12-01 00:00:00 | 25.5 | 1.5 |  | 27 |  | 25.5 | 1
2026-01-01 00:00:00 | 27 | 1.5 |  | 28.5 |  | 27 | 1
2026-02-01 00:00:00 | 28.5 | 1.5 |  | 30 |  | 28.5 | 1
2026-03-01 00:00:00 | 30 | 1.5 |  | 31.5 |  | 30 | 1
2026-04-01 00:00:00 | 31.5 | 1.5 |  | 33 |  | 31.5 | 1
2026-05-01 00:00:00 | 33 | 1.5 |  | 34.5 |  | 33 | 1
2026-06-01 00:00:00 | 34.5 | 1.5 |  | 36 |  | 34.5 | 1
2026-07-01 00:00:00 | 36 | 1.5 |  | 37.5 |  | 36 | 1
2026-08-01 00:00:00 | 37.5 | 1.5 |  | 39 |  | 37.5 | 1
2026-09-01 00:00:00 | 39 | 1.5 |  | 40.5 |  | 39 | 1
2026-10-01 00:00:00 | 40.5 | 1.5 |  | 42 |  | 40.5 | 1
2026-11-01 00:00:00 | 42 | 1.5 |  | 43.5 |  | 42 | 1
2026-12-01 00:00:00 | 43.5 | 1.5 |  | 45 |  | 43.5 | 1
2027-01-01 00:00:00 | 45 | 1.5 |  | 46.5 |  | 45 | 1
2027-02-01 00:00:00 | 46.5 | 1.5 |  | 48 |  | 46.5 | 1
2027-03-01 00:00:00 | 48 | 1.5 |  | 49.5 |  | 48 | 1
2027-04-01 00:00:00 | 49.5 | 1.5 |  | 51 |  | 49.5 | 1
2027-05-01 00:00:00 | 51 | 1.5 |  | 52.5 |  | 51 | 1
2027-06-01 00:00:00 | 52.5 | 1.5 |  | 54 |  | 52.5 | 1
2027-07-01 00:00:00 | 54 | 1.5 |  | 55.5 |  | 54 | 1
2027-08-01 00:00:00 | 55.5 | 1.5 |  | 57 |  | 55.5 | 1
2027-09-01 00:00:00 | 57 | 1.5 |  | 58.5 |  | 57 | 1
2027-10-01 00:00:00 | 58.5 | 1.5 |  | 60 |  | 58.5 | 1
2027-11-01 00:00:00 | 60 | 1.5 |  | 61.5 |  | 60 | 1
2027-12-01 00:00:00 | 61.5 | 1.5 |  | 63 |  | 61.5 | 1
2028-01-01 00:00:00 | 63 | 1.5 |  | 64.5 |  | 63 | 1
2028-02-01 00:00:00 | 64.5 | 1.5 |  | 66 |  | 64.5 | 1
2028-03-01 00:00:00 | 66 | 1.5 |  | 67.5 |  | 66 | 1
2028-04-01 00:00:00 | 67.5 | 1.5 |  | 69 |  | 67.5 | 1
2028-05-01 00:00:00 | 69 | 1.5 |  | 70.5 |  | 69 | 1
2028-06-01 00:00:00 | 70.5 | 1.5 |  | 72 |  | 70.5 | 1
2028-07-01 00:00:00 | 72 | 1.5 |  | 73.5 |  | 72 | 1
2028-08-01 00:00:00 | 73.5 | 1.5 |  | 75 |  | 73.5 | 1
2028-09-01 00:00:00 | 75 | 1.5 |  | 76.5 |  | 75 | 1
2028-10-01 00:00:00 | 76.5 | 1.5 |  | 78 |  | 76.5 | 1
2028-11-01 00:00:00 | 78 | 1.5 |  | 79.5 |  | 78 | 1
2028-12-01 00:00:00 | 79.5 | 1.5 |  | 81 |  | 79.5 | 1
2029-01-01 00:00:00 | 81 | 1.5 |  | 82.5 |  | 81 | 1
2029-02-01 00:00:00 | 82.5 | 1.5 |  | 84 |  | 82.5 | 1
2029-03-01 00:00:00 | 84 | 1.5 |  | 85.5 |  | 84 | 1
2029-04-01 00:00:00 | 85.5 | 1.5 |  | 87 |  | 85.5 | 1
2029-05-01 00:00:00 | 87 | 1.5 |  | 88.5 |  | 87 | 1
2029-06-01 00:00:00 | 88.5 | 1.5 |  | 90 |  | 88.5 | 1
2029-07-01 00:00:00 | 90 | 1.5 |  | 91.5 |  | 90 | 1
2029-08-01 00:00:00 | 91.5 | 1.5 |  | 93 |  | 91.5 | 1
2029-09-01 00:00:00 | 93 | 1.5 |  | 94.5 |  | 93 | 1
2029-10-01 00:00:00 | 94.5 | 1.5 |  | 96 |  | 94.5 | 1
2029-11-01 00:00:00 | 96 | 1.5 |  | 97.5 |  | 96 | 1
2029-12-01 00:00:00 | 97.5 | 1.5 |  | 99 |  | 97.5 | 1
2030-01-01 00:00:00 | 99 | 1.5 |  | 100.5 |  | 99 | 1
2030-02-01 00:00:00 | 100.5 | 1.5 |  | 102 |  | 100.5 | 1
2030-03-01 00:00:00 | 102 | 1.5 |  | 103.5 |  | 102 | 1
2030-04-01 00:00:00 | 103.5 | 1.5 |  | 105 |  | 103.5 | 1
2030-05-01 00:00:00 | 105 | 1.5 |  | 106.5 |  | 105 | 1
2030-06-01 00:00:00 | 106.5 | 1.5 |  | 108 |  | 106.5 | 1