David Seah produced a very nice Excel template that allows one to print out a year's worth of calendar on a single piece of paper that will fold to fit with 3x5 cards. It's great for planning because it's continuous, not starting a new line for each month.http://davidseah.com...og/compact-calendar/
(Images of my version at the bottom of this post 9/1/2008)
I took that idea, with his blessing, and gussied it up to be more automatic and to allow the user to pick any start date. It uses Excel-2007 conditional formatting so wouldn't work very well with Excel-2003.
Here's a link to my blog where I posted it.http://aedesigndu.bl...-calendar-excel.html
There's no money involved, I just got a kick out of generalizing it. I hope it's useful to others.
9/1/2008 At the request of others I've added the following information and pictures of how the end product and the data entry portion of the sheet look - there's also a sheet of instructions.What I did:
David Seah's version had to be manually updated whenever you changed the starting date of the calendar, picked a different starting day of the week, or decided to insert a holiday. Month Labels:
If the end of the week is in a different month than the prior week then display the month for that line.
To get the banner effect I had to develop conditional formatting. Since this was the first time I used it the "rules" that I used are a bit clunky, but they work.
Start of Year:
Make it a single named entry that is used in the first cell of the calendar. All the other cells flow from that one (and did in David's).Holidays:
Make a lookup based on the week of the year calculated as a simple sequence starting on the first week of the calendar (the lookup is hidden in a grouped column). This got a bit tricky because I had to write some logic to ensure that a holiday falling on a row that displayed the month name shows up in the next line. To make this work I decided to sacrifice David's ISO calendar week numbering scheme.
It could produce problems if someone puts holidays in succeeding rows starting with a month name - otherwise it's fine.
This is set to be formatted with conditional formatting using the "Weekday" function looking for either Saturday or Sunday. This makes them move in the display depending on which day of the week you use to start the calendar.Protection
I protected the sheets so that users couldn't inadvertently put entries in the wrong place. There's no password so anybody who wants to modify the sheet can do so with no problems = opensource(?).
Hope this helps.