Compact Calendar 2009

Compact Calendar 2009

For the latest version of the Compact Calendar, please go to

Download the 2009 Calendar Template


  1. Download using the link below, unzip the archive. In the Excel folder, you’ll see files named something like CompactCalendar.xlt. This is a Microsoft Excel spreadsheet template.

  2. Double-click the file (Windows) and a new spreadsheet will be created based on the template.

  3. Print it out, or annotate the calendar within Excel. Again, I just print them out; you could make a fancier “production calendar” too and print that instead, if you’re that type of person.

  4. Optionally you can copy the .xlt file into your Microsoft Excel templates folder. This gives you the ability to create new calendars using Excel’s New Document command.

US Version



p>16-us.gif Download USA 2008 by Dave Seah
Includes Sun-Sat and Mon-Sun (w/ ISO8601 week numbers) versions in ZIP archive. You can also download the PDF Sun-Sat and PDF Mon-Sun versions too!

16-us.gif Download USA 2009 by Dave Seah
Includes Sun-Sat and Mon-Sun (w/ ISO8601 week numbers) versions in ZIP archive. You can also download the PDF Sun-Sat and PDF Mon-Sun versions too!

2009 International Calendars

If you’ve made a version of the Compact Calendar for your locale and would like to share, put it on a page on your own website and I’ll link it here! I no longer host other people’s files, because it puts the support burden on me to maintain them.

16-ar.gif Argentina 2009 via Jeroen Sangers

16-at.gif Austria 2009 by Ronald

16-au.gif Australia 2009 by Working Solo
16-au.gif Australia/NSW 2009 by Diane (direct file download)

16-ca.gif Canada 2009 by andryou

16-cl.gif Chile 2009 via Jeroen Sangers
16-cl.gif Chile 2009 by Gabriel

16-cn.gif China (PRC) 2009 by iWorm

16-co.gif Colombia 2009 via Jeroen Sangers

16-co.gif Colombia 2009 by Javier Ferrand

16-dk.gif Denmark 2009 by henrik

16-ec.gif Ecuador 2009 via Jeroen Sangers

16-ee.gif Estonia 2009 by Eero

16-fr.gif France 2009 by Tisseurdetoile

16-de.gif Germany 2009 by Lennart Groetzbach

16-gt.gif Guatemala 2009 via Jeroen Sangers

16-gr.gif Greece 2009 by Gerasimos Tsiamalos

16-hk.gif Hong Kong 2009 by Catus Lee

16-id.gif Indonesia 2009 by Eka

16-it.gif Italy 2009 by Luca Magnani
16-it.gif Italy 2009 by Strategie Vincenti

16-jp.gif Japan 2009 by Yoshiomi KURISU

16-ly.gif Libya 2009 by Dino

16-my.gif Malaysia 2009 by Fred

16-mx.gif Mexico 2009 via Jeroen Sangers

16-nl.gif Netherlands 2009 by Pieter

16-nz.gif New Zealand 2009 by Jon Pawley

16-pe.gif Peru 2009 via Jeroen Sangers

16-pe.gif Phillipines 2009 by Arvin Pedregosa

16-pl.gif Poland 2009 by Mizo
16-pl.gif Poland 2009 by Jaason

16-pt.gif Portugal 2009 by Miguel Alho

16-ro.gif Romania 2009 by Andrei Neculau

16-ru.gif Russia 2009 by Ivan Bulychev

16-rs.gif Serbia 2009 by Goran Anicic

16-sg.gif Singapore 2009 by John Spencer Tan

16-sk.gif Slovakia 2009 by Uzivatel

16-sk.gif South Africa 2009 by Jason Bagley
16-sk.gif South Africa 2009 by Peter

16-es.gif Spain 2009 by Jeroen Sangers

16-se.gif Sweden 2009 by David Fredin

16-tw.gif Taiwan 2009 by yuanlin

16-gb.gif United Kingdom 2009 by (box-net download, unchecked)

16-uy.gif Uruguay 2009 via Jeroen Sangers

16-ve.gif Venezula 2009 via Jeroen Sangers



You can find more printable productivity tools on The Printable CEO™ Series page.


  1. Le TisseurDeToile 14 years ago

    Cool, a new version of the David Seah’s compact-calendar so this my french translation of this must have tools
    is here in french :
    Thanks for your work
    have a nice day.

  2. Dave Seah 14 years ago

    Thanks Le TisseurDeToile!

    I know that others have added their own versions already, so I’m going through my email to find them.

  3. E Sheng 14 years ago

    The Compact Calendar is very useful for me.
    Thanks~~~Dave Seah

  4. Jeroen Sangers 14 years ago

    A while ago I made a Spanish compact calendar for 2008 based on last year’s calendar, with separate calendars for the regions Cataluña, Madrid, Valencia and Lleida. After that special versions for Colombia and Mexico have been added:

  5. Paolo Ciarrocchi 14 years ago

    A new Italian version, including the ISO 8660 week numbers is available here:
    together with the 2007 version which I suggested in Aug.

  6. Genia 14 years ago

    David, I love your site and the information I’ve learned from you. Thanks for the new version of the Compact Calendar!

    One question/request: do you plan to do .pdf versions again, like you did for 2007? I don’t have Excel, and MS Works Spreadsheets doesn’t like multi-sheet Excel files.

    Thanks again for your insight!

  7. Dave Seah 14 years ago

    Genia: I’ve uploaded PDF printout versions for you. Enjoy!

  8. E Sheng 14 years ago

    Hi~ Dave
    I have made a Taiwan(Traditional Chinese) compact calendar for 2008, but I don’t know how to put it on the website.
    Can you tell me how can I do?

  9. Genia 14 years ago

    Dave, you’re a sweetheart. Thanks so much for the .pdf versions!

  10. Miguel Alho 14 years ago

    Hey Dave!

    Thanks for posting the 2008 calendar!

    I’ve put together a Portuguese (Portugal) version with the main / official holidays.

  11. Dave Seah 14 years ago

    E Sheng: Just upload it to your own website, write a blog post about it, and let me know, and I’ll link to it.

  12. E Sheng 14 years ago

    OK!! David



  13. Albert | UrbanMonk.Net 14 years ago

    Man, David. Just found your blog and I love it. Fantastic stuff – great design, content, you name it. You probably get a lot of comments like this, but hey you deserve it. I’ll be back to dig around more ;)

    Modern personal development, entwined with ancient spirituality.

  14. Zoltan Till 14 years ago
  15. David Mould 14 years ago

    Hi Dave,

    Thanks as always for sharing these ideas with us all.  I have modified the table to show the public holidays for Thailand for 2008.

  16. Dave Seah 14 years ago

    Thanks! Added Portugal, Taiwan, and will now add Hungarian and Thailand!

  17. Dave Seah 14 years ago

    Albert, David: thanks for the kind words! I really appreciate them! :-)

  18. Hyun-soo Lee 14 years ago

    I made the Korean translation:

    Thanks for your great idea!

  19. Strategievincenti 14 years ago

    Hi David,

    I love this calendar and I’ve made a little modification to the italian version: I’ve added a column with the number of the weeks, as long as I and my customers verry often referres to these numbers.

    My modded calendar is available here (


  20. Paolo 14 years ago

    Ciao Alex,
    I already did the same and David already linked my version:
    Italy 2008 w/ ISO8660 Weeks by Paolo Ciarrocchi

    Are there any differences in the two “implementations”?

    That said, I like your blog :-)

  21. Strategievincenti 14 years ago

    Ciao Paolo,

    I didn’t seen your version. I’m using the compact calendar since last year and I didn’t check back to this site lately, but only today to comunicate that I modded and publish my italian version.

    I didn’t know other people had the same need as I had and already made the addition of the weeks number.

    No there are no substantial changes, despite the fact that I located the number of the weeks just beside the column with the dates of Monday.

    have a nice day


  22. Dave 14 years ago

    I’ve made one for Alberta Canada, but it could be easily modified for the other provinces with different days. I also made some modifications as I like having lines to write on. I setup a light gray graph which would be useful for writing and drawing things like graphs and gantt charts. I also added a couple of lines at the top for subject heading and for the date or start/end time.

    Dave, feel free to post this up on your site:

  23. nibaq 14 years ago

    Dave, really great calendar. I am trying to make one for Kuwait but require more space in the Tables to add more holidays.

    Where can I edit the lookup table so I can make it larger?

  24. Dave Seah 14 years ago

    Hyun-soo, Dave: Awesome, thanks! BTW, Dave, if you could make the XLS file into a ZIP archive, that would be much more download-friendly.

    nibag: The HolidayTable can be expanded if you just insert rows in the middle, and not the ends. This should expand the range automatically (not guaranteed if you do it at the end). So, right-click the ROW number (all the way at the left of the spreadsheet), choose INSERT (or it might be INSERT ROW) from the menu, and that should add a row. To repeat the insert, you can type CTRL-Y a bunch of times.

  25. Sarah 14 years ago

    Republic of Ireland Holidays (Download UK one and edit holidays table – copy and paste in)
    1-Jan-08   New Year’s Day
    17-Mar-08   St. Patrick’s Day
    23-Mar-08   Easter
    24-Mar-08   Easter Monday
    5-May-08   May Day
    2-Jun-08   June Bank Holiday
    4-Aug-08   August Bank Holiday
    27-Oct-08   October Bank Holiday
    25-Dec-08   Christmas Day
    26-Dec-08   St. Stephen’s Day

    Very handy, thank you!

  26. Piter 14 years ago

    Hi David and everybody. A Dutch (Nederlands) and a Frisian (Frysk) translation can be found here:

  27. Nicholas Almeida 14 years ago

    Hi David,

    Great job again!

    I made the Brazilian translation with the national holidays and national holidays + São Paulo holidays.

  28. ole 14 years ago
  29. Dave 14 years ago

    Zip file:

    Please edit my original post if you can.

  30. Jorunn 14 years ago


    I’ve made a Norwegian version of the calendar available here:

  31. Canuck 14 years ago

    Thanks for this Dave.
    I’ve uploaded a Canadian-British Columbia calendar to the Wiki.
    Alberta Dave: Something happened to your’s as the last tab (Tables) is missing.

  32. Carla do Brasil 14 years ago

    Hello, Dave!

    Well, looks like Nicholas has made a brazilian version already. Anyway, my version is here:

    Thanks for sharing your idea!

  33. Steve Crane 14 years ago

    I’ve made a South African version but my blog doesn’t allow ZIP uploads.  I’ve tried to register on your wiki so I can upload it there but after five or six attempts at entering a string that matches the CAPTCHA, I gave up.  Is there some other way I can get it to you?

  34. Dave Seah 14 years ago

    Added all!

    Steve Crane: I’m sorry that the CAPTCHA isn’t working right…maybe I should disable it. I’ve turned it off for now…if anyone else has had trouble with it, please let me know.

  35. Steve Crane 14 years ago

    Now it says I’m not authorised to perform that action when I try to register.  I got past the CAPTCHA when I posted my last comment by typing it all in upper case even though it was displayed in lower case, but that didn’t work with the one on the registration page.  I hope I get past to post this comment.

  36. Dave Seah 14 years ago

    Steve: I think it requires numbers too at the end, but otherwise I’m not sure what the problem is. When I tested it I didn’t have any problems (Firefox). The authorization error occurs when Expression Engine thinks you are a bot, caused by repeated failed captcha attempts.

    Email me directly with what you want your username to be, and I will register you manually.

  37. Christi Milligan 14 years ago

    Hi Dave,

    Thanks for the great calendar! Question for you: I wanted to change the font color of the conditional formatting of the holidays but after changing the font color it did not actually update the calendar. What’s the trick to refreshing the calendar (so to speak) so the conditional formatting will take place again?


  38. Michael 14 years ago


    This is not a translation, but rather a port to Apple’s Numbers spreadsheet program.  I needed to use the functionality and thought it would be a good thing to share.  The functions were not compatible, so I had to do a little manual work, but visually it is the same.

    It can be found here:

    I have included links back to your site, but please let me know if you prefer I take it down.

    Thanks for the great tools.

    – Michael

  39. Shikhar 14 years ago

    Hi David,

    Thanks for the calendar, its amazingly very easy…

    I just made a India version for it, would like to share that on your website. Please let me know where can i email that.

    Thanks & Regards

  40. Malbong 14 years ago

    Compact calender is cool simple calendar.

    I made Korean version compact calendar.
    It’s little bit different.

  41. Dave Seah 14 years ago

    Christi: You need to set the formatting in the Conditional Formatting dialog box, not regular text formatting. Search help for “conditional formatting” for your version of Excel, and you should be able to figure it out from there. Good luck!

    Michael: Awesome! I added the link.

    Shikhar: If you don’t have hosting, register yourself on the public wiki, zip your file up, and then upload it and create a page for it. It’s all DIY here :-)

    Malbong: Thanks! Added!

  42. Eka 14 years ago

    Hi David. Thanks for your calendar. It’s very handy! You may find Indonesia version at

  43. Metaphox 14 years ago

    Hello David, I’ve put a Simplified Chinese version for China Mainland at

    Thanks for this great tool.

  44. Mhord 14 years ago

    Hello David, I have to say that all your printables are making my life better and organized. Also I uploaded in the wiki a Venezuelan version too. Hope to see more printables!

  45. shiny 14 years ago

    Hello David

    I edited and translated the compact calender into a Hong Kong version. (PS. Of course,it’s Traditional Chinese.)

    And I’ve upload it into you wiki

    For refer only: Gov HK:General holidays for 2008

    Thank you for your calendar.
    It’s simple & useful.

  46. stephen 14 years ago

    Yes this seems like quite a good thing

  47. software projecten 14 years ago

    I just made a India version for it, would like to share that on your website. Please let me know where can i email that.

  48. Michal Poppe 14 years ago

    I’ve just made slovak version (Slovakia). It’s available on my blog –

  49. Ron 13 years ago

    G’day, the “links” under “Download the Calendar Template” on the web page,
    are NOT links. Thanks for all the info, but can you get the links fixed so they work, please? Take care, Ron

  50. Dave Seah 13 years ago

    Ron: I am not following what your problem is. There are dozens and dozens of links on this page. Which ones specifically are not working? Many of them point to blog posts off-site. Some of them point to PDF files or ZIP files.

  51. Mary Kay 13 years ago

    Hi David,

    I am afraid that I am addicted to the Compact Calendar but am not smart enough to make my own for 2009. When might you be posting a new one?

    I know, no matter how much you give, it’s never enough! The people just want more.

    Many thanks for this great tool.

    Mary Kay

  52. Uzivatel 13 years ago

    I made Slovak version (Slovakia) 2009 –

  53. David 13 years ago

    Thanks for your job. Your blog is great!
    I’m trying to change the colour of the box in the first day of each month… I want it in white, like the other ones. Thanks!

  54. Julie Bates 13 years ago

    Hi David,

    I’ve happened on your site before (when I could leisurely cruise the blog world!) Now, I’m looking for a scale-able template for a 2009 calendar… I followed the rabbit trail and your compact calendar is great!  I also found the general start date version from James Mitchell site.  Really cool:)  I can’t use it for my purpose, but I’m going to use it for production scheduling for myself… thank you!

  55. Dave Seah 13 years ago

    Julie:  Someone actually called me up today and asked about the 2009 edition, so I said I could pop one out in about 15 minutes. Ooops. With all the rechecking of holidays, testing new features, and article prepwork, it’s really more like 4 hours.

    But it’s up now! :-)

  56. penny 13 years ago

    Dave, this is awesome. I’ll write up a list of jewish holidays for 08/09/10 to share.

  57. Gerasimos Tsiamalos 13 years ago

    Hey David! Great stuff once more. I’ve put together the Greek version of Compact Calendar 2009 :)

    It can be found at

    Thanx for that!

  58. Alexander Reif 13 years ago

    Hi Dave,

    shortly to inform you and your readers, that I’ve added to my blog (you already link to it) the 2009 calendar in ITALIAN language and that I’ve made it available in the following formats:

    1. XLS Excel
    2. PDF
    3. ODS OpenOffice (freeware !)
    4. Google Doc Spreadsheet (publicly accessible from anywhere you have access to an Internet connection !)


  59. Peter Hesse 13 years ago

    Is there a version that shows the holiday descriptions in the leftmost calendar anymore?  Your screenshots show it, but the calendar (at least S-S version) doesn’t have it.  Seems like a useful feature.  Thanks!

  60. nka 13 years ago

    Thanks. I found a typo though:

    “an visual advantage shared with the Gantt chart”

    It should be “a visual”

  61. Brian 13 years ago

    I added one modification to your calendar that you may want to consider.  Rather than shading the first day of each month, I alternated the background shading every other month.  So the entire months of January, March, May, etc. are shaded while February, April, June, etc. are not.  This makes it much easier to differentiate the months at a glance without sacrificing the compact “candy bar” design.  You might want to try it out and see if you like it.

  62. Kaushal Modi 13 years ago

    Hi David,  thanks for the calendar.  Inspired by your work, I developed my own calendar for the Fiscal year rotation.  You can access that from my blog

  63. John 13 years ago

    I just discovered this calendar, and it looks awesome!

    I was wondering, if anybody would be willing to work on a student version, that goes from about August-July?

    If somebody could point me in the right direction, I guess I could make it for myself!

  64. Kaushal Modi 13 years ago

    @John, You can try using my calendar at; I started with David’s idea and built up on it.  It will show you 12 months from the month and year you specify in the Excel sheet.

  65. Roland 13 years ago

    Great Tool! Just adapted the 2009 version to german including Austrian Holidays.

  66. Andy 13 years ago

    Just a quick question. Why is Thursday marked as R on the US 2009 PDF?


  67. Lennart 13 years ago

    Created the German version and updated the .xls sheet. Wow the holidays are also automatically updated based on the calendar year you choose.

  68. David Fredin 13 years ago


    Thanks for the new version, here is a swedish translation of the 2009 version:

  69. Luca Magnani 13 years ago


    thank You very much for the new version.

    The updated italian version for the 2009 (with and without week numbers) can be found at following url:


  70. Le TisseurDeToile 13 years ago

    Hello, nice work as usual,

    I have update the french version of the compact-calendar it cant be found here, I have made the Microsoft Office and the OpenOffice Version.

    You can find it here

    Hopes It Help.

    Thanks for your work
    have a nice day.

  71. Jeroen Sangers 13 years ago

    As I commented on you post about the new versions, I have created compact calendars in Spanish for (amongst others) Argentine, Chile, Colombia, Equador, Spain, United States, Guatemala, Mexico and Peru.

  72. Jeroen Sangers 13 years ago

    Oops, forgot to mention the location of these calendars:

  73. Zoltan Till 13 years ago

    Hi Dave, I updated the Hungarian Calendar.

    Here is the new version:

  74. David Fredin 13 years ago

    The link to the swedish version for 2009 has two “http” in it, so the link is invalid.

  75. Ellis Godard 13 years ago

    Here’s a mod that permits any fiscal or academic term, of any length, by allowing the user to specify both the start and end dates – a variation on Jim Mitchell’s mod, with high praise for David’s original from both of us!

    Feel free to distribute freely, and/or (esp David) to adopt the modifications (3 more on the way). Credit due appreciated, but keep the change. ;)


  76. Chi 13 years ago

    The Compact Calendar Creator (listed under “Other Versions”) generates wrong calendars—they’re one day off.

  77. Michael Flenniken, Jr 13 years ago

    I’ve made a couple changes to ease the pain of updating holidays after changing the year. Of course, holidays that change dates (Easter) are still messy, but most of them will update with the year change.

    Basically, you enter the date without the year (as a string) and it tacks the year on and makes a datestamp for the vlookup to use

    Excel Template: 3 Template:

  78. Henrik Fylking-Nielsen 13 years ago

    Hi David,

    Danish translation is ready here:

    BR Henrik

  79. Mike 13 years ago

    I added a few tweaks.

    Here’s the details on the first:

    Convert and Merge Number and Date

    You can change the year but the Holidays
    didn’t automatically adjust.  So, I, with
    the help of the folks at MrExcel, figured
    out a way to adjust the Holidays automatically
    by plugging in the Year from the main Calendar
    into the Holiday Dates.  This way, when you
    change to a new year, the Holidays update too,
    and from the same location, so no having to
    change each date every time you update.

    One other thing I did was to change the Year
    to a drop down list (hidden on the Holidays page
    in Columns D-H.  It now goes all the way up to
    2050.  And beyond that, it’s a simple matter to
    simply update the numbers in the range.

    The last thing that I haven’t entirely figured out
    yet is the whole Holiday Friday, or Monday, or
    as in Thanksgiving, the Last Thursday of November.

    Using the info from this page:

    Calculate Last Sunday and First Sunday in the Month:

    I used his example to calculate (after setting
    up pointer tables, also on the Holidays page
    the Last Thursday of November for Thanksgiving.

    It should also be easy then to calculate any other
    1st, 2nd, 3rd, last etc special dates.

    Hope these prove useful.

    Here’s the (Office 2007) sheet saved as a template.

  80. Mike 13 years ago

    Just to let you know.

    There were improvements suggested
    to the formula used to calculate
    Holiday dates.

    I’ve included the changes in the
    formula, as well as the details
    in my tweaks.

    Same link.

    So, if you downloaded it earlier,
    you might want to download it again.

    Thanx and Credit to all for their
    suggestions and help as well as to
    David for the original.

  81. Nursegirl 13 years ago

    Here’s an updated Numbers template. Michael’s doesn’t update to 2009 well. This one should work except on leap years.

    Or direct link:

  82. Nursegirl 13 years ago

    Michael’s Numbers template doesn’t update easily as the year changes. I’ve made one that will work most of the time, but isn’t optimized for Leap Years.

  83. Dave Seah 13 years ago

    Thanks everyone for your updates and contributions! I’m in the process of making updates for 2009 from the various places I’m getting links. If you don’t see yours, let me know :-)

    Reminder: I will not host files; I will only link to webpages.

  84. Yen Pham 13 years ago

    Very nice!

  85. Eero 13 years ago

    Hi David,

    I have posted an Estonian version of Compact Calendar 2009 at the following address:

    Thanks for the great work!

  86. Eka 13 years ago

    Hi, David.
    I have uploaded Indonesian version for 2009 at

    Thanks for your work!

  87. Jeroen Sangers 13 years ago

    I have added the Compact Calendar of Paraguay to

  88. Miguel Alho 13 years ago

    Hi David, Took me a while to get to it this year, but I ajusted the calender with Portugal’s holidays. The post is at :

    Have a great year!!!

  89. Peter 13 years ago

    Hello David,

    A bit late, but the dutch and frisian versions can be found at again.

    Happy Newyear!

  90. J Mark 13 years ago

    I have found the compact calendar extremely useful for planning my longer term (usually a quarter or more)responsibilities for work and personal.  It is also an “at a glance” overview of the entire upcoming quarter or year.  I recommend that everyone explore how it may be adopted and adapted to improve your planning and execution.

  91. yuanlin 13 years ago

    I made Traditional Chinese version for Taiwan

  92. rdsu 13 years ago

    The Portuguese link is wrong.

    Can you fix it?


  93. John Spencer Tan 13 years ago

    Hi David,

    I’ve imported the Singapore public holidays and school holidays into a Singapore Edition, and posted it on my blog at

  94. Dave Seah 13 years ago

    Added all the calendars in the comments above, and fixed the Portugal link.

  95. rudy 13 years ago

    hi David, thanks a lot for this calendar. I hope you don’t mind if i linked this page from mine.
    Happy new year

  96. Peter 13 years ago

    Hi David,
    I’ve posted a Monday-Sunday version with South African holidays at

    thanks for this and your other work


  97. spag 13 years ago

    Hi Dave,

    thanks for the great design!

    I created my Hungarian version at

    My own modifications, two of which could apply to the US original too:
    – I needed to add two more holiday-like day groups and conditional formattings to incorporate some swapped workdays and Saturdays in the coloring.
    – because the conditional formatting for 1st of month is before the one for holidays, it is not possible to decide if a 1st day is holiday or not. My workaround is to swap the formattings and uncheck “stop if true”, but this only works perfectly in the new Excel version.
    – As the Christmas of 2008 and 1/1/10 are visually included in the calendar of 2009, I included them in the holiday listings too for proper coloring.

  98. Boris 13 years ago

    Hey, David, is there a version of this calendar wherein the work day starts on a Saturday? I’ve changed work locations and the workweek starts on Saturdays here.

    Hope you could help me. Your compact calendar is really of great help for me.

    Thanks and best regards,

  99. Lucía 13 years ago

    Muy útil, muchas gracias