Excel Templates | Excel Spreadsheets | 2011 Calendars

2011 Calendars

Posted on October 24, 2010
Filed Under Calendar | 20 Comments

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.

2011 Calendar

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, 15,551 hits)

  2011 Calendar with Holiday Information in one Worksheet (Excel 2003) (91.5 KiB, 8,897 hits)

  2011 Calendar Landscape (Excel 2003) (60.0 KiB, 14,519 hits)

  2011 Calendar Portrait (Excel 2003) (110.5 KiB, 7,209 hits)

  2011 Calendar Portrait (Excel 2007/2010) (71.7 KiB, 6,153 hits)

  2011 Calendar Landscape (Excel 2007/2010) (21.8 KiB, 10,083 hits)

(Visited 488 times, 2 visits today)


20 Responses to “2011 Calendars”

  1. ottym on October 25th, 2010 1:45 pm

    2011 calendar — August returns 1 day later!

  2. Barbara on October 25th, 2010 9:41 pm

    These calendars are great. Thanks! In 2011 Calendar Landscape (2003) and Portrait (2003) versions, if the date is in March, no date populates with red, green or blue. Can you take a look at that? Thanks!!

  3. xapie128 on October 27th, 2010 12:27 am

    For Barbara:
    March works OK for me. Are you putting an H, E, or R in column H?

  4. matthew on November 10th, 2010 8:41 pm

    These calendars are awesome perfect for what im looking for, my only problem is that i need to increase the important events amount from 20 to about 100+, i tried copy and paste of the cell previous thinking this may copy the formula but this hasn’t worked, please help.

  5. edy on November 12th, 2010 1:49 am

    Something false with August, when i mark 17 for holiday, the calender choose 18. how can i fix it? thanks
    all of them is very good calender.. very helpfully.

  6. e on November 13th, 2010 2:17 am

    Also having a problem with August being one day ahead (using 2011_Calendar_Portrait_Vertical_With_Notes_V1.3).

    Love the calendar a lot!

  7. G on November 23rd, 2010 3:47 pm

    Hi great calendar, I was wondering is it possible to add more than 3 colour coded options? (I’m using the 2011 Calendar Landscape (Excel 2007/2010)version)

  8. BT on December 4th, 2010 1:06 pm

    2011_Calendar_Landscape_V1.2 (Excel 2007/2010 version), for March it doesnt highlight any reminder, holiday or event. Any ideas?

  9. PC on December 6th, 2010 2:44 am

    I believe all the calendars have the wrong dates for Columbus and Veterans Day.
    October 10 is Columbus day and November 11 is Veterans Day

  10. Joe Ungar on December 7th, 2010 6:11 pm

    On the 2011 calendar, I would like to another section for additional events. How can I add one?

  11. luanna on December 8th, 2010 6:40 am

    Please can you send me a 2010 version of this great 2011 calender ?

  12. Dutt on December 8th, 2010 10:41 am

    Thank you,
    For Color change use the Tool | Formating | Manage Formating option

  13. Ade on December 9th, 2010 1:49 am

    Wow, you’re amazing.
    Great job.

  14. Govardhan on December 29th, 2010 1:00 pm

    thanks really this is useful for personal and for office use.

  15. Lorne on December 29th, 2010 8:02 pm

    This calendar is really excellent and is right up the alley of what i was looking for. However, i am having a similar problem like the others where March does not highlight regardless of dates entered in the appropriate column. Can you help with this please?

  16. Jen on January 20th, 2011 5:02 pm

    Hi all..for the march issue – just go into the last two colored in “blank days” and change 2010 to 2011. That fixed it for me.

  17. Jason on January 24th, 2011 9:37 pm

    If one want to enter a date range to fill in is that possible?

  18. Jason on February 1st, 2011 3:12 pm

    Anyone? Admin? Can anyone tell me how I can go in to modify this? I would liek to build something soi that if a date is overlapping with another event we can still showboth colors

  19. Brigitte on February 10th, 2011 5:20 am

    hello I am using the Event Planner calendar – we love it but we need more than three line items in the calendar section per date. We would like to have 6 lines of availability for each date within the calendar – how do we do that? Thanks so much these are really great resources.

  20. 2011 calendar template with holidays – CALENDAR – CALENDAR on September 16th, 2011 1:15 am

    […] 2011, 2011 calendar with holidays, Calendar, excel 2010 template, Excel Calendar, Printable Calendarhttp://exceltemplate.net/calen […]

Leave a Reply