Spreadsheet: 79358d1279639645-conditional-formatting-dates-holssickabs-test
Sheet: TOM

 |  |  |  |  | TOM - 2 0 1 0
 |  |  |  |  | JANUARY |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  | [NAME]
SICKNESS |  |  |  |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
PERSONAL APPT |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 |  |  | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 |  |  | 1 | 2 | 3 | 4 | 5 | 6
HOLIDAY |  |  |  |  | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
WEEKENDS/ BANK HOLDAYS |  |  |  |  | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 |  |  |  |  | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 |  | 28 |  |  |  |  |  |  |  | 28 | 29 | 30 | 31
 |  |  |  |  | 2010-01-31 00:00:00
NUMBER OF DAYS HOLIDAY TAKEN
= |  |  |  |  | APRIL |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 |  |  |  |  |  |  |  | 1 |  |  |  | 1 | 2 | 3 | 4 | 5
NUMBER OF OCCASIONS SICK TAKEN |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
= |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 27 | 28 | 29 | 30
NUMBER OF PERSONAL APPIONTMENTS |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
=
 |  |  |  |  | JULY |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  | SEPTEMBER
 |  |  |  |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30 | 31 |  |  |  |  |  | 26 | 27 | 28 | 29 | 30
 |  |  |  |  | OCTOBER |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  | DECEMBER
 |  |  |  |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | 1 | 2 | 3 | 4
 |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30 |  |  |  |  |  | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  | 31
HOLIDAYS |  |  |  |  |  |  |  |  | SICKNESS |  |  |  |  |  |  |  |  |  |  |  | ABSENSES
DATE FROM | DATE TO | DAYS TAKEN | BAL OF DAYS | AUTHORISED | DATE FORM RECIEVED |  |  |  | DATE FROM |  | DATE TO |  | NO OF DAYS / HRS |  | REASON |  | DATE FORM RECIEVED |  |  |  | DATE FROM |  | DATE TO |  | NO OF DAYS / HRS |  | REASON |  | DATE FORM RECIEVED
2010-01-01 00:00:00 | 2010-01-08 00:00:00
2010-02-02 00:00:00 | 2010-02-04 00:00:00