Spreadsheet: 770441d1646068931-data-entry-to-defined-cells-in-a-table-from-a-seperate-user-input-selection-section-time-and-attendance-calendar
Sheet: Calendar

 |  |  |  | Time and Attendance Records 2022 |  |  |  |  |  |  |  |  |  |  | Key | On Call | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half Day (Morning) | H1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half Day (Afternoon) | H2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overtime | Ox
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time off in Lieu | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday | B
 | Holiday Entitlement |  |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 |  |  | Sick | S
 | Holidays taken |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity / Paternity | M
 | Holidays remaining |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Off work / other | N
 | Sat | 1st | Jan
 | Sun | 2nd | Jan
 | Mon | 3rd | Jan | b | b | b | b | b | b | b | b | b | b
 | Tue | 4th | Jan
 | Wed | 5th | Jan | O2 |  | O1.5
 | Thu | 6th | Jan | L2 | L3 |  | H
 | Fri | 7th | Jan
 | Sat | 8th | Jan
 | Sun | 9th | Jan
 | Mon | 10th | Jan
 | Tue | 11th | Jan
 | Wed | 12th | Jan
 | Thu | 13th | Jan
 | Fri | 14th | Jan
 | Sat | 15th | Jan
 | Sun | 16th | Jan
 | Mon | 17th | Jan
 | Tue | 18th | Jan
 | Wed | 19th | Jan
 | Thu | 20th | Jan
 | Fri | 21st | Jan
 | Sat | 22nd | Jan
 | Sun | 23rd | Jan
 | Mon | 24th | Jan
 | Tue | 25th | Jan
 | Wed | 26th | Jan
 | Thu | 27th | Jan
 | Fri | 28th | Jan
 | Sat | 29th | Jan
 | Sun | 30th | Jan
 | Mon | 31st | Jan
 | Tue | 1st | Feb
 | Wed | 2nd | Feb
 | Thu | 3rd | Feb
 | Fri | 4th | Feb
 | Sat | 5th | Feb
 | Sun | 6th | Feb
 | Mon | 7th | Feb
 | Tue | 8th | Feb
 | Wed | 9th | Feb
 | Thu | 10th | Feb
 | Fri | 11th | Feb
 | Sat | 12th | Feb
 | Sun | 13th | Feb
 | Mon | 14th | Feb
 | Tue | 15th | Feb
 | Wed | 16th | Feb
 | Thu | 17th | Feb
 | Fri | 18th | Feb
 | Sat | 19th | Feb
 | Sun | 20th | Feb
 | Mon | 21st | Feb
 | Tue | 22nd | Feb
 | Wed | 23rd | Feb
 | Thu | 24th | Feb
 | Fri | 25th | Feb
 | Sat | 26th | Feb
 | Sun | 27th | Feb
 | Mon | 28th | Feb
 | Tue | 1st | Mar
 | Wed | 2nd | Mar
 | Thu | 3rd | Mar
 | Fri | 4th | Mar
 | Sat | 5th | Mar
 | Sun | 6th | Mar
 | Mon | 7th | Mar
 | Tue | 8th | Mar
 | Wed | 9th | Mar
 | Thu | 10th | Mar
 | Fri | 11th | Mar
 | Sat | 12th | Mar
 | Sun | 13th | Mar
 | Mon | 14th | Mar
 | Tue | 15th | Mar
 | Wed | 16th | Mar
 | Thu | 17th | Mar
 | Fri | 18th | Mar
 | Sat | 19th | Mar
 | Sun | 20th | Mar
 | Mon | 21st | Mar
 | Tue | 22nd | Mar
 | Wed | 23rd | Mar
 | Thu | 24th | Mar
 | Fri | 25th | Mar
 | Sat | 26th | Mar
 | Sun | 27th | Mar
 | Mon | 28th | Mar
 | Tue | 29th | Mar
 | Wed | 30th | Mar
 | Thu | 31st | Mar
 | Fri | 1st | Apr
 | Sat | 2nd | Apr
 | Sun | 3rd | Apr
 | Mon | 4th | Apr
 | Tue | 5th | Apr
 | Wed | 6th | Apr
 | Thu | 7th | Apr
 | Fri | 8th | Apr
 | Sat | 9th | Apr
 | Sun | 10th | Apr
 | Mon | 11th | Apr
 | Tue | 12th | Apr
 | Wed | 13th | Apr
 | Thu | 14th | Apr
 | Fri | 15th | Apr
 | Sat | 16th | Apr
 | Sun | 17th | Apr
 | Mon | 18th | Apr
 | Tue | 19th | Apr
 | Wed | 20th | Apr
 | Thu | 21st | Apr
 | Fri | 22nd | Apr
 | Sat | 23rd | Apr
 | Sun | 24th | Apr
 | Mon | 25th | Apr
 | Tue | 26th | Apr
 | Wed | 27th | Apr
 | Thu | 28th | Apr
 | Fri | 29th | Apr
 | Sat | 30th | Apr
 | Sun | 1st | May
 | Mon | 2nd | May
 | Tue | 3rd | May
 | Wed | 4th | May
 | Thu | 5th | May
 | Fri | 6th | May
 | Sat | 7th | May
 | Sun | 8th | May
 | Mon | 9th | May
 | Tue | 10th | May
 | Wed | 11th | May
 | Thu | 12th | May
 | Fri | 13th | May
 | Sat | 14th | May
 | Sun | 15th | May
 | Mon | 16th | May
 | Tue | 17th | May
 | Wed | 18th | May
 | Thu | 19th | May
 | Fri | 20th | May
 | Sat | 21st | May
 | Sun | 22nd | May
 | Mon | 23rd | May
 | Tue | 24th | May
 | Wed | 25th | May
 | Thu | 26th | May
 | Fri | 27th | May
 | Sat | 28th | May
 | Sun | 29th | May
 | Mon | 30th | May
 | Tue | 31st | May
 | Wed | 1st | Jun
 | Thu | 2nd | Jun
 | Fri | 3rd | Jun
 | Sat | 4th | Jun
 | Sun | 5th | Jun
 | Mon | 6th | Jun
 | Tue | 7th | Jun
 | Wed | 8th | Jun
 | Thu | 9th | Jun
 | Fri | 10th | Jun
 | Sat | 11th | Jun
 | Sun | 12th | Jun
 | Mon | 13th | Jun
 | Tue | 14th | Jun
 | Wed | 15th | Jun
 | Thu | 16th | Jun
 | Fri | 17th | Jun
 | Sat | 18th | Jun
 | Sun | 19th | Jun
 | Mon | 20th | Jun
 | Tue | 21st | Jun
 | Wed | 22nd | Jun
 | Thu | 23rd | Jun
 | Fri | 24th | Jun
 | Sat | 25th | Jun
 | Sun | 26th | Jun
 | Mon | 27th | Jun
 | Tue | 28th | Jun
 | Wed | 29th | Jun
 | Thu | 30th | Jun
 | Fri | 1st | Jul
 | Sat | 2nd | Jul
 | Sun | 3rd | Jul
 | Mon | 4th | Jul
 | Tue | 5th | Jul
 | Wed | 6th | Jul
 | Thu | 7th | Jul
 | Fri | 8th | Jul
 | Sat | 9th | Jul
 | Sun | 10th | Jul
 | Mon | 11th | Jul
 | Tue | 12th | Jul
 | Wed | 13th | Jul
 | Thu | 14th | Jul
 | Fri | 15th | Jul
 | Sat | 16th | Jul
 | Sun | 17th | Jul
 | Mon | 18th | Jul
 | Tue | 19th | Jul
 | Wed | 20th | Jul
 | Thu | 21st | Jul
 | Fri | 22nd | Jul
 | Sat | 23rd | Jul
 | Sun | 24th | Jul
 | Mon | 25th | Jul
 | Tue | 26th | Jul
 | Wed | 27th | Jul
 | Thu | 28th | Jul
 | Fri | 29th | Jul
 | Sat | 30th | Jul
 | Sun | 31st | Jul
 | Mon | 1st | Aug
 | Tue | 2nd | Aug
 | Wed | 3rd | Aug
 | Thu | 4th | Aug
 | Fri | 5th | Aug
 | Sat | 6th | Aug
 | Sun | 7th | Aug
 | Mon | 8th | Aug
 | Tue | 9th | Aug
 | Wed | 10th | Aug
 | Thu | 11th | Aug
 | Fri | 12th | Aug
 | Sat | 13th | Aug
 | Sun | 14th | Aug
 | Mon | 15th | Aug
 | Tue | 16th | Aug
 | Wed | 17th | Aug
 | Thu | 18th | Aug
 | Fri | 19th | Aug
 | Sat | 20th | Aug
 | Sun | 21st | Aug
 | Mon | 22nd | Aug
 | Tue | 23rd | Aug
 | Wed | 24th | Aug
 | Thu | 25th | Aug
 | Fri | 26th | Aug
 | Sat | 27th | Aug
 | Sun | 28th | Aug
 | Mon | 29th | Aug
 | Tue | 30th | Aug
 | Wed | 31st | Aug
 | Thu | 1st | Sep
 | Fri | 2nd | Sep
 | Sat | 3rd | Sep
 | Sun | 4th | Sep
 | Mon | 5th | Sep
 | Tue | 6th | Sep
 | Wed | 7th | Sep
 | Thu | 8th | Sep
 | Fri | 9th | Sep
 | Sat | 10th | Sep
 | Sun | 11th | Sep
 | Mon | 12th | Sep
 | Tue | 13th | Sep
 | Wed | 14th | Sep
 | Thu | 15th | Sep
 | Fri | 16th | Sep
 | Sat | 17th | Sep
 | Sun | 18th | Sep
 | Mon | 19th | Sep
 | Tue | 20th | Sep
 | Wed | 21st | Sep
 | Thu | 22nd | Sep
 | Fri | 23rd | Sep
 | Sat | 24th | Sep
 | Sun | 25th | Sep
 | Mon | 26th | Sep
 | Tue | 27th | Sep
 | Wed | 28th | Sep
 | Thu | 29th | Sep
 | Fri | 30th | Sep
 | Sat | 1st | Oct
 | Sun | 2nd | Oct
 | Mon | 3rd | Oct
 | Tue | 4th | Oct
 | Wed | 5th | Oct
 | Thu | 6th | Oct
 | Fri | 7th | Oct
 | Sat | 8th | Oct
 | Sun | 9th | Oct
 | Mon | 10th | Oct
 | Tue | 11th | Oct
 | Wed | 12th | Oct
 | Thu | 13th | Oct
 | Fri | 14th | Oct
 | Sat | 15th | Oct
 | Sun | 16th | Oct
 | Mon | 17th | Oct
 | Tue | 18th | Oct
 | Wed | 19th | Oct
 | Thu | 20th | Oct
 | Fri | 21st | Oct
 | Sat | 22nd | Oct
 | Sun | 23rd | Oct
 | Mon | 24th | Oct
 | Tue | 25th | Oct
 | Wed | 26th | Oct
 | Thu | 27th | Oct
 | Fri | 28th | Oct
 | Sat | 29th | Oct
 | Sun | 30th | Oct
 | Mon | 31st | Oct
 | Tue | 1st | Nov
 | Wed | 2nd | Nov
 | Thu | 3rd | Nov
 | Fri | 4th | Nov
 | Sat | 5th | Nov
 | Sun | 6th | Nov
 | Mon | 7th | Nov
 | Tue | 8th | Nov
 | Wed | 9th | Nov
 | Thu | 10th | Nov
 | Fri | 11th | Nov
 | Sat | 12th | Nov
 | Sun | 13th | Nov
 | Mon | 14th | Nov
 | Tue | 15th | Nov
 | Wed | 16th | Nov
 | Thu | 17th | Nov
 | Fri | 18th | Nov
 | Sat | 19th | Nov
 | Sun | 20th | Nov
 | Mon | 21st | Nov
 | Tue | 22nd | Nov
 | Wed | 23rd | Nov
 | Thu | 24th | Nov
 | Fri | 25th | Nov
 | Sat | 26th | Nov
 | Sun | 27th | Nov
 | Mon | 28th | Nov
 | Tue | 29th | Nov
 | Wed | 30th | Nov
 | Thu | 1st | Dec
 | Fri | 2nd | Dec
 | Sat | 3rd | Dec
 | Sun | 4th | Dec
 | Mon | 5th | Dec
 | Tue | 6th | Dec
 | Wed | 7th | Dec
 | Thu | 8th | Dec
 | Fri | 9th | Dec
 | Sat | 10th | Dec
 | Sun | 11th | Dec
 | Mon | 12th | Dec
 | Tue | 13th | Dec
 | Wed | 14th | Dec
 | Thu | 15th | Dec
 | Fri | 16th | Dec
 | Sat | 17th | Dec
 | Sun | 18th | Dec
 | Mon | 19th | Dec
 | Tue | 20th | Dec
 | Wed | 21st | Dec
 | Thu | 22nd | Dec
 | Fri | 23rd | Dec
 | Sat | 24th | Dec
 | Sun | 25th | Dec
 | Mon | 26th | Dec
 | Tue | 27th | Dec
 | Wed | 28th | Dec
 | Thu | 29th | Dec
 | Fri | 30th | Dec
 | Sat | 31st | Dec