Forum Discussion
Convert Excel Data into Calendar
mdockter Please see attached file. It's based on one of many Calendar templates available on-line. This particular one (Family Event Planner) came up a while ago in this forum in connection when a runner wanted to use it to plan a training schedule for a marathon. The original template wasn't very useful, so I changed it around a bit so that it would display the actual event(s) for the day, rather than just state that "Something is due today".
Without much effort, I could turn it into an Expense calendar. Though, bear in mind that it uses some of the newer functions like TEXTJOIN and FILTER. See if that would work for you.
If not, a Pivot table could probably achieve something useful as well.
mdockter Please see attached file. It's based on one of many Calendar templates available on-line. This particular one (Family Event Planner) came up a while ago in this forum in connection when a runner wanted to use it to plan a training schedule for a marathon. The original template wasn't very useful, so I changed it around a bit so that it would display the actual event(s) for the day, rather than just state that "Something is due today".
Without much effort, I could turn it into an Expense calendar. Though, bear in mind that it uses some of the newer functions like TEXTJOIN and FILTER. See if that would work for you.
If not, a Pivot table could probably achieve something useful as well.
Hello Riny_van_Eekelen
I'm working on a small project and have a list of start dates and end dates with Task names that I would like the ability to convert to a Calendar view. Can you help?
Thanks
Best to start you own thread. This one is three years old and already has a solution. Provide some example data and mention which Excel version you work with and on what platform (PC or Mac).