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
Team Templates
Vincent VALENTIN in Microsoft Teams AMA on
8 Replies
Loan Amortization Template
Kim Boyd in Formulas and Functions on
3 Replies
Cost estimator for small scale catering
Louisa Dira in Excel on
12 Replies
How to add the dates using the time criteria ?
Aditya Jadhav in Excel on
7 Replies