Spreadsheet: 741984d1627471398-pulling-working-days-from-a-range-sample
Sheet: SHEET1

 | PAID HOLIDAYS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNPAID HOLIDAYS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SICKNESS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APPOINTMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-24 00:00:00 |  | 2021-02-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-27 00:00:00 |  | 2021-05-27 00:00:00
RUDI | JANUARY |  |  |  | WORKING HOURS PER DAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  |  | UNPAID HOLIDAYS USED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  |  | SICK DAYS USED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY |  |  | APPOINTMENTS (Hours) USED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-28 00:00:00 |  | 2021-05-28 00:00:00
 | FEBRUARY |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-29 00:00:00 |  | 2021-06-21 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-30 00:00:00 |  | 2021-06-22 00:00:00
 | APRIL |  |  |  | TOTAL HOLIDAYS (- BANK HOLS) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-31 00:00:00 |  | 2021-07-16 00:00:00
 | MAY |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-11 00:00:00 |  | 2021-04-30 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-09 00:00:00
 | JULY |  |  |  | YEAR USED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-12 00:00:00
 | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-13 00:00:00
 | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-14 00:00:00
 | OCTOBER |  |  |  | YEAR REMAINING |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-15 00:00:00
 | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-16 00:00:00
 | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-04 00:00:00
 | DATE FROM | DATE TO | #Days | #Hours | Notes | Month | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | DATE FROM | DATE TO | #Days | #Hours | Notes | Month | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | DATE FROM | DATE TO | #Days | #Hours | Notes | Month | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  | DATE | #Hours | Notes | Month | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  |  | 2021-06-10 00:00:00
 | 2021-12-23 00:00:00 | 2021-12-31 00:00:00 | 5 |  | Christmas 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-30 00:00:00
 | 2021-02-11 00:00:00 | 2021-02-11 00:00:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2
 | 2021-04-09 00:00:00 | 2021-04-09 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2
 | 2021-04-12 00:00:00 | 2021-04-16 00:00:00 | 2.5 |  | 12/14/15 Half Days. 16th Full Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-16 00:00:00 | 2021-07-16 00:00:00 | 1
 | 2021-04-29 00:00:00 | 2021-04-29 00:00:00 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-30 00:00:00 | 2021-04-30 00:00:00 | 1 |  | This was down as hol in SS but was meant to be Sick
 | 2021-05-05 00:00:00 | 2021-05-05 00:00:00 | 0.5
 | 2021-06-04 00:00:00 | 2021-06-04 00:00:00 | 1
 | 2021-06-10 00:00:00 | 2021-06-10 00:00:00 | 0.5
 | 2021-07-30 00:00:00 | 2021-07-30 00:00:00 | 1
 |  |  | 1 |  | <-- Any date range added to B28 to B29 is not showing in the list in CALL ANYTIME yet all other rows are fine
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 3
 |  |  | 0.5
 |  |  | 2