Merging Existing Template Formulas

Hello,

 

I am interested in creating a daily and weekly meeting schedule that resembles a meeting calendar you can print from Outlook, Gmail, etc. I couldn't find an existing Excel template. I have found two templates that I think will work individually, but I need help with merging them into different schedules. Here are the two templates that I like:

• http://templates.office.com/en-au/Student-schedule-TM00000023
• http://templates.office.com/en-us/Daily-work-schedule-TM02780252

For the daily calendar, I would like to be able to select a specific date (available in template number 1) and have only the meetings assigned to that date display using color coded blocks (available in template number 2).

 

For the weekly calendar, I would like to be able to select a date (available in template number 1) and have the meetings for the remaining days in that week display using color coded blocks (available in template number 2).

 

I've included images of the preferred outcomes below.

 

I appreciate any support anyone can provide, so thanks in advance!

 

 

Daily calendar

 

 

Weekly calendar