Hello all,
I am trying to build a calendar that, if the calendar date falls within the class dates, located to the right, it will display a value.
I have the Calendar days easy and displaying the day of the week above them.
I have the class start date and the predicted end date
I need a formula that populates beneath the date, when we will be required to schedule an instructor
<tbody>
</tbody>
That pulls from this table, which states what dates the classes will actually be in attendance
<tbody>
</tbody>
End goal: I will know that Monday-Thursday I need two instructors a day, but on Friday, I only need one.
<tbody>
</tbody>
Any help would be greatly appreciated, even if it's to say that it cannot be done; any suggestions for improvement are very welcome!
-Shawn
I am trying to build a calendar that, if the calendar date falls within the class dates, located to the right, it will display a value.
I have the Calendar days easy and displaying the day of the week above them.
I have the class start date and the predicted end date
I need a formula that populates beneath the date, when we will be required to schedule an instructor
Monday | Tuesday | Wednesday | Thursday | Friday |
02jan | 03jan | 04jan | 05jan | 06jan |
<tbody>
</tbody>
That pulls from this table, which states what dates the classes will actually be in attendance
Class name | Class module | Start date | end date |
#1 | class module 1 | 01 jan | 18 jan |
#2 | class module 2 | 01 jan | 05 jan |
<tbody>
</tbody>
End goal: I will know that Monday-Thursday I need two instructors a day, but on Friday, I only need one.
Monday | Tuesday | Wednesday | Thursday | Friday |
02jan | 03jan | 04jan | 05jan | 06jan |
#1 | #1 | #1 | #1 | #1 |
#2 | #2 | #2 | #2 | - |
<tbody>
</tbody>
Any help would be greatly appreciated, even if it's to say that it cannot be done; any suggestions for improvement are very welcome!
-Shawn