There are always some needs of new calendars because years keep changing, probably until the end of the world… Last year I made several type of 2010 calendars and two months from now, the year will change into 2011 which need new calendars that can be used for that year.
I created several type of 2011 calendars where some of them are using the same templates with the 2010 version, but there are new calendars which have different layout and different templates for putting holiday, event and reminder information. I created one single worksheet where the calendar and information which will be used to colorize the date are sharing the same worksheet and can be printed in one piece of paper.
You can download the calendar templates with long filename below to try the features. You can also learn the excel formula created to bring those features. It is a simple formula which uses the power of conditional formatting in Excel 2003 (with 3 condition limitation) and Excel 2007/2010 to colorize the dates and the related information.
Type your date in the date colums, your holiday, event or reminder description in related columns and type of those information, “H” for holiday, “E” for event, and “R” for reminder. Once you put the character, the color of corresponding date and information will be changed according to preset color. Red for “H”, blue for “E” and green for “R”. In excel 2007/2010, I add one conditional formatting formula to show and hide the initial information. Just type “v” inside the box on top of the calendar and all initial information (H,E, and R) will be hidden. Clear the “v” and those hidden initial will be shown up again.
Feel free to play around with all the calendars. I will add some others with different layout and features later.
2011 Calendar with Holiday Information in one Worksheet (Excel 2007/2010) (50.9 KiB, 14,879 hits)
2011 Calendar with Holiday Information in one Worksheet (Excel 2003) (91.5 KiB, 8,702 hits)
2011 Calendar Landscape (Excel 2003) (60.0 KiB, 14,331 hits)
2011 Calendar Portrait (Excel 2003) (110.5 KiB, 7,002 hits)
2011 Calendar Portrait (Excel 2007/2010) (71.7 KiB, 5,970 hits)
2011 Calendar Landscape (Excel 2007/2010) (21.8 KiB, 9,847 hits)