Formula to look at a range of cells, match dates within the range and pull data.

I'm trying to do something that I'm not sure I can do with excel...but I'm hoping I'm wrong. In the attached spreadsheet, which is a leave tracker document for supervisors in my area to use to track leave usage, there's a drop down for the different types of leave. We have a 9 pay period review period that is a sliding window and we have a calendar year review period. I need to be able to fill out the leave tracker but differentiate and grab that info based on the 9 week review period indicated in cells C8 and C9. For example, this spreadsheet shows a date range of 03/03/2019-03/16/2019. In the tracker i need that to break out by planned versus unplanned and broken down by LEAVE TYPE in the charts below. The tracker will show how much leave was used, the leave type, if it was planned, sick leave, or FMLA. And I'd like the formula to be able to count up the hours used by UNPLANNED v. PLANNED and broken down by TYPE of leave used. I'm hoping the Excel Think Tank can help because I just can't get it.

THANK YOU!!!

Next question - if you can help, awesome! I think I may have done some bad formulas. When a date is entered for tracking the leave used, the supervisor will enter the date in column J. I have column K set to equal that cell but in the format of "dddd" to display the day of the week. This is causing problems when I'm trying to track the "Days Out of Office" because I can't match it to "Monday" since that cell value isn't technically "Monday" but rather "04/01/019" - is there a work around for this?

The cells I'm specifically trying to do the formula are for G28:G33 for the report period and H28:H33 for the whole list of absences.

Updated spreadsheet is attached.

YOU ARE AMAZING MY FRIEND!!

I thought I was all done and I got a NEW request from my manager. I've added a new area to the tracker to the right of the tracked leave used. My manager would like a VISUAL representation of the leave, so I know I have some conditional formatting to do. I have the dates laid out to indicate when leave is used. What I need to do is match that to the date used on the left, match it to sick leave, planned, unplanned, or FMLA (4 rules for conditional formatting). When it's all said and done that date in columns V:AA need to conditionally format to match the tracker on the left but I'm not sure how to do that. I know there's a rule for each condition that will go in the actual formatting, but not sure that formula? Again, I appreciate your help!

1.) For X date find if it's listed in column K. If it's a yes in column O, then turn the font red.
2.) For X date find if it's listed in column K. If it's a yes in column P, then fill the cell green.
3.) For X date find if it's listed in column K. If it's a no in column P, then fill the cell red.
4.) For X date find if it's listed in column K. If it's a yes in column Q, then fill the cell gray.

THANK YOU THANK YOU THANK YOU!!! Presented this at our all supervisors meeting and THEY LOVED IT!! Thanks for all your help!

Thanks Bernie, that's actually helped me with a similar problem!