Forum Discussion
School Master Calendar
The formulas in rows 3, 5, 7, etc. on the December tab use 11 as month number. That should be 12 for December.
The two sheets for November work correctly as far as I can tell - what exactly is wrong according to you?
How about the attached template?
That looks like a good start to what I'm hoping for. The color coding is only going to the date, though, not the events. It would be GREAT if the color coding went to each event on a given day--BUT if that can't happen, it probably shouldn't be included on the monthly view at all.
This calendar works by placing all events for a day in the same cell. It is not possible to apply different colors to different lines in a cell.
An alternative might be to split each day into multiple cells. That would require the template to be reworked.
Really appreciate your (speedy) assistance!
What about this thought....If there is a master sheet with everything listed, and I only use two "categories" of "Event" and "Facility Reservation," is it possible to have a "November Facility Reservation" sheet that those items populate to and a "November School Calendar" (as an example) for those items to populate to? This would essentially give us an events calendar and a facility reservation calendar.
I split the January and November sheets so that you can see whether you like it and how it works.
If so, you can do the same for the other months.