Forum Discussion
Excel Monthly Personal Planner
Sharpe411 Oh my! Yet another example of a calendar template that isn't very useful. Looks fancy with the spiral wire to mimic a paper calendar, assuming that the workbook attached is the template you are using.
Begin by right-clicking on the Tab name "Monthly Planner" and press Unhide. Now you can unhide the Lists tab and you'll see the 8 months that feed the drop down box. These 8 months are dynamic though. 2 months back and 6 months forward from the current month. I guess the designer thought that would be sufficient. If you want 12 months, expand the list, making sure that the formulae that calculate the month and year are updated correctly.
Now that you have the "12-month calendar" (see attached), don't think you can do much with it. All you have is a digital representation of just "a paper calendar". Print each month, on-by-one, and start writing down your notes on the hard copies. The template has no built in functionality that allows you to store notes by date that can be displayed for the chosen month. Your choice, though.
Sharpe411 Oh my! Yet another example of a calendar template that isn't very useful. Looks fancy with the spiral wire to mimic a paper calendar, assuming that the workbook attached is the template you are using.
Begin by right-clicking on the Tab name "Monthly Planner" and press Unhide. Now you can unhide the Lists tab and you'll see the 8 months that feed the drop down box. These 8 months are dynamic though. 2 months back and 6 months forward from the current month. I guess the designer thought that would be sufficient. If you want 12 months, expand the list, making sure that the formulae that calculate the month and year are updated correctly.
Now that you have the "12-month calendar" (see attached), don't think you can do much with it. All you have is a digital representation of just "a paper calendar". Print each month, on-by-one, and start writing down your notes on the hard copies. The template has no built in functionality that allows you to store notes by date that can be displayed for the chosen month. Your choice, though.
