Home

Merging Existing Template Formulas

Highlighted
Tandylyn TERRY
Occasional Visitor

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:

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

 

Related Conversations
Hide a column with merged cell across the column
suionhk in Excel on
7 Replies
Excel Table
Reza Dashti in Excel on
1 Replies