Sunday, December 30, 2012

Excel Customizable Virtual Calendar for Any Year




There are two Excel 2007 workbooks in the zip file. Each is a virtual calendar, which means you can make it for any year you desire simply by inputting the year into a cell! This calendar is designed to print in landscape on a regular sheet of paper. It is fully customizable: you can add an image of your choosing for each month, change the font styles and change the fill colors. Furthermore, you can easily have the weekends displayed first simply by adding a number in a cell! The highlighted color will automatically be filled in for Saturday and Sunday. If you wish to change the fill color for the weekends, you will need to modify the existing conditional formatting rules for the first two date columns as well as the seventh. I hope you shall enjoy this any-year calendar and have lots of fun creating for your family and friends! Select thumbnail for preview.
  • One calendar does not highlight any holidays.
  • One calender will highlight the following U.S. holidays:

New Year's Day, Martin Luther King's Birthday, Valentine's Day, St. Patrick's Day, Easter, Mother's Day, Father's Day, Independence Day, Labor Day, Halloween, Thanksgiving, Christmas Day.

 "In their hearts humans plan their course, but the Lord establishes their steps." Proverbs 16:9

Click here to download ...

1 comment:

  1. This calendar is so perfect! I add pictures of my sweet grandkids and post it up next to the computer. Thank you!!

    ReplyDelete