Spreadsheet: 117685d1312963889-problems-with-if-statements-planner-holidays
Sheet: Staff Holiday

 |  |  | Director | Contracts Department |  |  |  |  |  | Administration |  |  | Garage |  | HSE
Week Commencing | Date | Day | P Rushton | D Byrne | D Kemp | C Newell | A Brunton | S Hodgson | D Kerry | K Wilson | H Sockett | S Sturman | M Griffiths | D Wood | B Green
3rd Jan 2011 | 3rd | Mon
 | 4th | Tue
 | 5th | Wed
 | 6th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 7th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
10th Jan 2011 | 10th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 11th | Tue |  | Authorised |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 12th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 13th | Thu |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | Maternity
 | 14th | Fri |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | Parental
17th Jan 2011 | 17th | Mon |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | Paternity
 | 18th | Tue |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | Suspension
 | 19th | Wed |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  | Training
 | 20th | Thu
 | 21st | Fri
24th Jan 2011 | 24th | Mon
 | 25th | Tue
 | 26th | Wed
 | 27th | Thu
 | 28th | Fri
31st Jan 2011 | 31st | Mon
 | 1st | Tue
 | 2nd | Wed
 | 3rd | Thu
 | 4th | Fri
7th Feb 2011 | 7th | Mon
 | 8th | Tue
 | 9th | Wed
 | 10th | Thu
 | 11th | Fri
14th Feb 2011 | 14th | Mon
 | 15th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 16th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 17th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 18th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
21st Feb 2011 | 21st | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 22nd | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 23rd | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 24th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 25th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
28th Feb 2011 | 28th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 1st | Tue
 | 2nd | Wed
 | 3rd | Thu
 | 4th | Fri
7th Mar 2011 | 7th | Mon
 | 8th | Tue
 | 9th | Wed
 | 10th | Thu
 | 11th | Fri
14th Mar 2011 | 14th | Mon
 | 15th | Tue
 | 16th | Wed
 | 17th | Thu
 | 18th | Fri
21st Mar 2011 | 21st | Mon
 | 22nd | Tue
 | 23rd | Wed
 | 24th | Thu
 | 25th | Fri
28th Mar 2011 | 28th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 29th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 30th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 31st | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 1st | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
4th April 2011 | 4th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 5th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 6th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 7th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
 | 8th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
11th April 2011 | 11th | Mon
 | 12th | Tue
 | 13th | Wed
 | 14th | Thu
 | 15th | Fri
18th April 2011 | 18th | Mon
 | 19th | Tue
 | 20th | Wed
 | 21st | Thu
 | 22nd | Fri
25th April 2011 | 25th | Mon
 | 26th | Tue
 | 27th | Wed
 | 28th | Thu
 | 29th | Fri
2nd May 2011 | 2nd | Mon
 | 3rd | Tue
 | 4th | Wed
 | 5th | Thu
 | 6th | Fri
9th May 2011 | 9th | Mon
 | 10th | Tue
 | 11th | Wed
 | 12th | Thu
 | 13th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
16th May 2011 | 16th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 17th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 18th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 19th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 20th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
23rd May 2011 | 23rd | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 24th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 25th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
 | 26th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 27th | Fri
30th May 2011 | 30th | Mon
 | 1st | Tue
 | 2nd | Wed
 | 3rd | Thu
 | 4th | Fri
6th June 2011 | 6th | Mon
 | 7th | Tue
 | 8th | Wed
 | 9th | Thu
 | 10th | Fri
13th June 2011 | 13th | Mon
 | 14th | Tue
 | 15th | Wed
 | 16th | Thu
 | 17th | Fri
20th June 2011 | 20th | Mon
 | 21st | Tue
 | 22nd | Wed
 | 23rd | Thu
 | 24th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
27th June 2011 | 27th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 28th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 29th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 30th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 1st | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
4th July 2011 | 4th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 5th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 6th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
 | 7th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 8th | Fri
11th July 2011 | 11th | Mon
 | 12th | Tue
 | 13th | Wed
 | 14th | Thu
 | 15th | Fri
18th July 2011 | 18th | Mon
 | 19th | Tue
 | 20th | Wed
 | 21st | Thu
 | 22nd | Fri
25th July 2011 | 25th | Mon
 | 26th | Tue
 | 27th | Wed
 | 28th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 29th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
1st Aug 2011 | 1st | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 2nd | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 3rd | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 4th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 5th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
8th Aug 2011 | 8th | Mon |  |  |  |  | Holiday |  |  |  |  |  |  |  |  |  | Paternity
 | 9th | Tue |  |  |  |  | Holiday |  |  |  |  |  |  |  |  |  | Suspension
 | 10th | Wed |  |  |  |  | Holiday |  |  |  |  |  |  |  |  |  | Training
 | 11th | Thu |  |  |  |  | Holiday
 | 12th | Fri |  |  |  |  | Holiday
15th Aug 2011 | 15th | Mon
 | 16th | Tue
 | 17th | Wed
 | 18th | Thu
 | 19th | Fri
22nd Aug 2011 | 22nd | Mon | Holiday
 | 23rd | Tue
 | 24th | Wed
 | 25th | Thu
 | 26th | Fri
29th Aug 2011 | 29th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 30th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 31st | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 1st | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2nd | Fri |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Unpaid
5th Sept 2011 | 5th | Mon |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Maternity
 | 6th | Tue |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Parental
 | 7th | Wed |  | Holiday |  | Holiday |  |  |  |  |  |  |  |  |  |  | Paternity
 | 8th | Thu |  | Holiday |  | Holiday |  |  |  |  |  |  |  |  |  |  | Suspension
 | 9th | Fri |  | Holiday |  | Holiday |  |  |  |  |  |  |  |  |  |  | Training
12th Sept 2011 | 12th | Mon |  | Holiday |  | Holiday
 | 13th | Tue |  | Holiday |  | Holiday
 | 14th | Wed |  |  |  | Holiday
 | 15th | Thu |  |  |  | Holiday
 | 16th | Fri |  |  |  | Holiday
19th Sept 2011 | 19th | Mon
 | 20th | Tue
 | 21st | Wed
 | 22nd | Thu
 | 23rd | Fri
26th Sept 2011 | 26th | Mon
 | 27th | Tue
 | 28th | Wed
 | 29th | Thu
 | 30th | Fri
3rd Oct 2011 | 3rd | Mon
 | 4th | Tue
 | 5th | Wed
 | 6th | Thu
 | 7th | Fri |  |  |  | Holiday
10th Oct 2011 | 10th | Mon |  |  |  | Holiday
 | 11th | Tue |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Holiday
 | 12th | Wed |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Authorised
 | 13th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 14th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
17th Oct 2011 | 17th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 18th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 19th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 20th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 21st | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
24th Oct 2011 | 24th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 25th | Tue
 | 26th | Wed
 | 27th | Thu
 | 28th | Fri
31st Oct 2011 | 31st | Mon
 | 1st | Tue
 | 2nd | Wed
 | 3rd | Thu
 | 4th | Fri
7th Nov 2011 | 7th | Mon
 | 8th | Tue
 | 9th | Wed
 | 10th | Thu
 | 11th | Fri
14th Nov 2011 | 14th | Mon
 | 15th | Tue
 | 16th | Wed
 | 17th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 18th | Fri |  |  |  | Holiday |  |  |  |  |  |  |  |  |  |  | Authorised
21st Nov 2011 | 21st | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 | 22nd | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 23rd | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 24th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 25th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
28th Nov 2011 | 28th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
 | 29th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
 | 30th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 1st | Thu
 | 2nd | Fri
5th Dec 2011 | 5th | Mon
 | 6th | Tue
 | 7th | Wed
 | 8th | Thu
 | 9th | Fri
12th Dec 2011 | 12th | Mon
 | 13th | Tue
 | 14th | Wed
 | 15th | Thu
 | 16th | Fri
19th Dec 2011 | 19th | Mon
 | 20th | Tue
 | 21st | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday
 | 22nd | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorised
 | 23rd | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
26th Dec 2011 | 26th | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 27th | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unpaid
 | 28th | Wed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maternity
 | 29th | Thu |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parental
 | 30th | Fri |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paternity
2nd Jan 2012 | 2nd | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Suspension
 | 3rd | Tue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 | 4th | Wed
 | 5th | Thu
 | 6th | Fri