Spreadsheet: 150551d1334598772-i-am-stumped-at-this-function-searching-range-for-any-a-then-sum-the-numbers-2012-leave-scheduleshared
Sheet: Shannon Augustine

 |  | [NAME]
 |  | FY 2012 2-Week Leave Periods BEGIN |  | A - Annual |  |  |  |  |  | CE - Comp Earned |  |  |  |  |  | L - Leave Without Pay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: Annual leave earned each pay period depends on your length of service |  |  |  | Less than 3 years ………….. 4 hrs. 3 - 15 years …………………. 6 hrs.     (10 hrs. in last pay period) 15 years and over …………... 8 hrs.
 |  |  |  | S - Sick |  |  |  |  |  | CA - Comp Absent |  |  |  |  |  | [NAME]
 |  |  |  | H - Holiday |  |  |  |  |  | CL - Court |  |  |  |  |  | F - Floating Day
 |  |  |  | Daily Record of Leave Used During Each Pay Period Example: If you are sick 4 hours, enter S in first column and 4 in 2nd column under the appropriate day. If you take a day of annual leave, enter A, 8, respectively for that day.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Leave |  |  | Sick Leave |  |  | Comp Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | U | Bal | E | U | Bal | E | U | Bal
 |  | Pay Date |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT |  | SUN |  |  |  | 78 |  |  | 32
2011-09-12 00:00:00 | 2011-09-25 00:00:00 | 1 |  | A | 8 | A | 4 | S | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 2 | S | 2 |  |  |  |  | 6 |  |  | 4
2011-09-26 00:00:00 | 2011-10-09 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-10-10 00:00:00 | 2011-10-23 00:00:00 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-10-24 00:00:00 | 2011-11-06 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-11-07 00:00:00 | 2011-11-20 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-11-21 00:00:00 | 2011-12-04 00:00:00 | 6 |  |  |  |  |  |  |  | H |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-12-05 00:00:00 | 2011-12-18 00:00:00 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2011-12-19 00:00:00 | 2012-01-01 00:00:00 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | H |  | H |  | H |  | H |  |  |  |  |  | 6 |  |  | 4
2012-01-02 00:00:00 | 2012-01-15 00:00:00 | 9 |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 4
2012-01-16 00:00:00 | 2012-01-29 00:00:00 | 10 |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-01-30 00:00:00 | 2012-02-12 00:00:00 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-02-13 00:00:00 | 2012-02-26 00:00:00 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-02-27 00:00:00 | 2012-03-11 00:00:00 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-03-12 00:00:00 | 2012-03-25 00:00:00 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-03-26 00:00:00 | 2012-04-08 00:00:00 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-04-09 00:00:00 | 2012-04-22 00:00:00 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 3.5 | S | 3 |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-04-23 00:00:00 | 2012-05-06 00:00:00 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-05-07 00:00:00 | 2012-05-20 00:00:00 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-05-21 00:00:00 | 2012-06-03 00:00:00 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-06-04 00:00:00 | 2012-06-17 00:00:00 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-06-18 00:00:00 | 2012-07-01 00:00:00 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-07-02 00:00:00 | 2012-07-15 00:00:00 | 22 |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-07-16 00:00:00 | 2012-07-29 00:00:00 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-07-30 00:00:00 | 2012-08-12 00:00:00 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-08-13 00:00:00 | 2012-08-26 00:00:00 | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
2012-08-27 00:00:00 | 2012-09-09 00:00:00 | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 4
 |  |  |  | H = Holidays Observed