Bookmark and Share

Excel Calendar PRO is an extension of Vertex42's free Excel Calendar. Our free calendar template has had over 600,000 downloads! Excel Calendar PRO provides a few additional features, such as mini calendars and a button to automatically create a 12-month calendar in a new workbook, beginning with the month of your choice. It allows you to add birthdays, anniversaries, and other special events. It also includes holidays such as Easter, Christmas, Mother's Day, Father's Day, Labor Day, Valentine's Day and important dates-to-remember such as Daylight Savings and the dreaded Tax deadline.

Excel Calendar PRO - Landscape
Excel Calendar PRO - Portrait

Screenshot

Excel Calendar PRO 1.7

Generate multiple-month calendars starting with any year and month using this Excel calendar generator. With just a single click of a button you can create a calendar in a separate macro-free Excel Workbook.

This version includes many important holidays and events, and you can add your own annual events such as birthdays and anniversaries before generating the calendar.

Great for creating academic calendars starting with the month of your choice.

guarantee
(60-day 100% Money-Back Guarantee)

Buy Excel Calendar Pro  Buy Now

Price: $9.95

License: Single User

Immediate Download
Version: 1.7.0

Required: Microsoft Excel 2002/XP/2003 and 2007

Technical Support: Contact Vertex42 via email if you have questions about Excel Calendar PRO.

FEATURES:

1) Annual holidays and events
Only in the Pro Version

  • Christmas and Other Fixed-Date Holidays
  • Easter - A custom VBA function
  • Thanksgiving - 4th Thursday of November
  • ML King Day - 3rd Monday of January
  • Mother's Day - 2nd Sunday of May
  • Father's Day - 3rd Sunday of June
  • Parents' Day - 4th Sunday in July
  • Labor Day - 1st Monday of September
  • President's Day - 3rd Monday of February
  • Columbus Day - 2nd Monday of October
  • Memorial Day - Last Monday of May
  • Daylight Savings
  • Vernal and Autumnal Equinox (1900 - 2099)
  • June and December Solstices (1900 - 2099)
  • Passover, Rosh Hashanah, Yom Kippur, and Chanukkah
  • Ramadan (for 2009 - 2017)
  • Aviation Day, Patriot Day, and Kwanzaa
  • Add your own birthdays, anniversaries, and other special events.

2) Convenient Previous and Next Month Calendars

Excel Calendar PRO includes two linked images that display the previous and next month in the form of mini calendars. (These can be seen in the screenshot).

Mini Monthly Calendars

3) Simple Dynamic Color Scheme Controls

In order to add a bit of style to the calendar, you can modify the color palette using a very simple set of color controls. The HUE changes the main color scheme based upon the spectrum above the slider. The saturation varies from gray (0) to full color (100).

Excel Calendar Color Controls
Dynamic color scheme controls.

This calendar uses Conditional Formatting to vary the background colors based upon whether the day of the week is Saturday or Sunday.

4) Automatically Copy the Calendar to a New Workbook
Only in the Pro Version

Excel Calendar PRO includes a macro button that lets you automatically copy the calendar into a new Excel workbook. The values and formats are copied, including the column widths and the color scheme. The mini calendars are also copied into the new workbook. This creates a macro-free calendar in Excel that you can customize to your heart's content.

View the Screenshot to see the buttons and controls.

5) Quickly Create a 12-Month Calendar
Only in the Pro Version

Using the "Create 12-Month Calendar" button, you can easily create a customizable calendar in a new workbook, where each month is on a separate worksheet. An option in the Settings worksheet allows you to modify how many months are created, so you can create a 6-month or 24-month calendar. This is great for creating academic calendars which usually start in July or August and run for 13-14 months.

Creating calendars using this macro is the preferred way to use Excel Calendar PRO because the calendar is created in a separate macro-free workbook that allows you complete control over formatting and event entry. Using features already built into Excel, you could (1) merge cells to add events that spans multiple days, (2) add hyperlinks that link to special event sites like conferences, (3) add images and clip-art.

6) Easy Printing

The excel calendar has already been set up to print to a normal letter-sized sheet of paper (in landscape). However, you can customize the spreadsheet to print to other sizes and orientations (by changing column widths and font sizes and/or using Excel's page-setup to fit the spreadsheet to other sizes).

Printing a Specific Range of Cells to Any Size Paper in Excel:

  1. Go to File > Print Area > Set Print Area.
  2. Select the range of cells you want to print.
  3. Go to File > Page Setup
  4. In the Page tab, select the "Fit To: " option
  5. Select print preview and change other printing options as needed.
  6. To change the paper size in the Page Setup window, press the "Options..." button and depending upon your printer, the paper size selection may be in the "Advanced..." settings.

7) *NEW* - Switch to Monday-first

Due to the increasing number of requests from our international customers, you can now change the calendar so that Monday is the first day of the week, with a single click! This is done using a checkbox like the one below:

monday-first

What This Template Won't Do

It won't store the entries that you make into a database so that you can keep a history of your appointments or plans. Don't expect this calendar to behave like Outlook or other calendar software. It doesn't remind you when events are coming up.

 

 

 
 

Become a Fan of Vertex42
Find Vertex42 on Facebook