Schedule of Events Template

This Yearly Schedule of Events template uses conditional formatting to highlight dates in mini calendars based upon a chosen "event type" such as "holiday". You can define your own custom event types if you don't want to use the types already in the template (holiday, event, note). This type of event schedule is commonly used by schools or other organizations for showing events going on throughout the year.

Calendrier (French)

This perpetual calendar template is a French version of the Vertex42 Perpetual Calendar with some of the common holidays in France.

Plantilla Calendario (Spanish)

I created my first official non-English Excel template. The new Plantilla Calendario is a new perpetual calendar template that creates both yearly and monthly calendars for any year in the future. You can also change the start month in order to create a school calendar. The page also contains printable calendars in PDF format.

Photo Calendar

The new Photo Calendar template lets you create and print a calendar using photos and pictures that you insert.

You can fully customize the calendars, adding events, clipart, etc.

This template was designed for printing the photo calendar on 8 1/2" x 11" paper in portrait orientation. Instructions are given on the download page for how to print a mini folding wall calendar.

Printable Monthly Planner

This Monthly Planner Template is great for printing letter-size planner pages for a 3-ring binder. It is more than just a calendar. It includes a To-Do list and sections for monthly Goals and Notes. Unlike many of my other calendar templates, this one allows you to copy the worksheet so that you can have multiple months within the same workbook, which is nice if you are using this for planning rather than just printing a blank planner page.

Weekly Planner

This weekly planner spreadsheet lets you print a letter-size planner page that will fit common 3-ring binders. You can enter yearly events like birthdays and holidays and it will automatically add them to the planner (up to 3 events/holidays per day).

I've also created a couple printable weekly planners that you can download from this page in PDF format. One is based on the Excel version of the weekly planner, and the other is a very basic planner page without any bells and whistles.

Daily Planner

I created a new Printable Daily Planner that lets you print a letter-size planner page that will fit common 3-ring binders. There are no macros and it doesn't tie in to a database, so if you're looking for an electronic planner - something similar to the way Outlook works - this daily planner is probably not for you. However, you CAN enter yearly events like birthdays and holidays and it will automatically add them to the planner.

I've been toying with the idea of creating planner pages for some of the smaller size daily planners, but it's easier (and can even be cheaper) to just buy the refill planner pages available at office supply stores.

New Years Resolution Checklist

I just finished creating a New Year's Resolution Calendar for Excel that fits a whole year on a single page. It is designed to be used as a checklist for your top three daily goals, but it is pretty easy to modify to add or remove rows.

Weekly Calendar Template

I'm not sure why I waited until now to create a weekly calendar. But, alas, here it is. The spreadsheet is pretty easy to use, as long as the changes are not too drastic. The worksheet with all the fancy formulas is hidden.

School Calendar Templates

Download a collection of free school calendar Excel templates, including monthly calendars, school-year calendars, and event calendars. The screenshot on the left is an example of just one of them. Some of the templates work for any school year, and the monthly calendars are available for 2007-2008, 2008-2009, 2009-2010, and 2010-2011.