Forum Discussion
Solved
Year View for Dynamic Calendar
Anyone able to assist with a yearly view for a dynamic calendar? I have a month view which pulls dates associated with a deployment from a table (I got this template from someone in the excel communi...
See the attached version. It's not the most elegant, but it should work.
That template is just not designed to be used as you intend. It's full with named ranges and named formulas. For example two of them that are used very often are referring to the values in B3 and C3. Then there are also named formulas that calculate day and month numbers based on the named ranges mentioned before. Just copying the January calendar will not work. You'll need begin by discecting the template first to get a thorough understanding of how it works. Then adjust all affected formulas in the copied/pasted calendars. That's quite some work.