Forum Discussion
Populate dynamic calendar with table data
Mthammon The calendar template you chose isn't well suited for what you have in mind. As most templates, it's packed with tricks and treats. This particular one is full of named formulae. Neat, but near to impossible to tweak without destroying something else. But, there are templates "out there" that can do what you need. Not too long ago, I adapted such a template for another user on this forum, though it uses the rather new FILTER function. The original template just highlighted that "something was due" on a particular date without specifying what. After my adaption it actually displays the assignment(s) due on a given day.
I took a few columns from your data sheet and dumped them in the template. See if it works for you (file attached). If not, keep searching for a better template.
SeaSears That makes perfect sense, though the template dealt with in this thread is not suitable for it. you need to enter assignments on a daily basis. But I wonder why you would want to have a calendar in Excel to begin with. Why not use e.g. the calendar app you probably already have on your computer, e.g. in Outlook? Just a thought. I would never use a calendar developed in Excel myself.
Riny_van_Eekelen hi I’d also like to have the “event” show on the calendar each day from start to finish. I’m using this as a holiday tracker for a project team so seeing the days each person will be out of office with overlap would be helpful.
Excel-ent Can only repeat my previous response. Sorry!