Forum Discussion
Help with Organizing University Assignment Calendar
KIP344 These kind of templates are in fact quite useless. Packed with "hidden treasures" that make it hard to follow through what's going on. And as you noticed already, flagging that "something is due today" is no good. One would need to know what is due today.
Anyhow, if you have have MS365 you can use the FILTER and TEXTJOIN functions to create the daily input in the Month and Week views. Though, the formulae aren't very straight-forward. If this doesn't work for you, I'd suggest you scrap this template all-together and summarise your assignment list with a plain pivot table. True, not as "fancy" as the template, but it works.
Note that the original formulae contained a part where a concatenated textual date like "September 1, 2021" was transformed to a proper date value. Being on a European system, my Excel didn't like that. I needed to change that particular part so that it would transform "1-September-2021" to a date value.
File attached.