Create your own daily planner using our Free Printable Daily Planner template for Excel. Most commercial daily planners have page refills that you can buy, and the original planner often costs a lot as well. Our daily planner template was designed specifically for common (inexpensive) 3-ring binders and you can print the planner pages using regular letter-size paper.

Advertisement

If you don't have such a busy schedule that you need this level of detail, try our Printable Weekly Planner or Printable Monthly Planner instead.

Printable Daily Planner

for Excel
Daily Planner Template
Screenshots: 1
Download
For: Excel 2003 or later
Download
For: OpenOffice Calc

Template Details

License: Personal Use
View Agreement >
(not for distribution or resale)
Support:
Visit Support Page >

Other Versions

 

"No installation, no macros - just a simple spreadsheet" - by


Advertisement

Description

This Daily Planner is a spreadsheet template that lets you print a planner page for any day of the year. First enter all the birthdays and other yearly events. When you change the date, up to 3 events per day will be shown automatically.

Macro Version: Included in the download is a version that contains a macro for printing multiple days at a time. The filenames of the two daily planner files should make it obvious which one is which.

Update 7/31/2013: I've added a new Excel 2007+ version (listed under "Other Versions") that lets you print two days at a time. You can also make duplicate copies of the planner worksheet within the same workbook. Printing two days at a time allows you to take advantage of the duplex mode on your printer (if it has that mode) for printing on both sides of a piece of paper.

Daily Planner Features

If you calculate how much it costs to print your own daily planner pages vs. buying ready-made planners, you'll probably find that printing your own is NOT necessarily cheaper. Ultimately someone has to pay for the paper and the ink.

The main advantage of creating your own is the ability to customize your daily planner. For example, if you are a student, you may want to change the "People to Call" section into a "Homework Due" section. Also, if you work a weird shift that is constantly changing times, you could make your day start at 7:00am or 9:00pm.

Holidays and Birthdays

This template is more fancy than your typical daily planner because you can record the month and day of all your family and friends' birthdays and when you change the date to print a new day, up to 3 events and 3 holidays will be shown automatically. Holidays are shown under the day in red font, and events (like birthdays) are shown in the Remember section. The limit of 3 per day is because I haven't figured out a formula for listing more than 3 and I don't want to use a VBA macro.

Other Daily Planner Features

  • The ISO Week Number is shown under the date as W01-7 where 01 is the week number and 7 is the day of the week. In the ISO standard, Monday is the first day of the week, and Week 01 is the week containing Jan 4th.

  • Events and holidays are highlighted in the mini calendars at the top. The current day also uses a unique highlight. The highlighting is controlled using Conditional Formatting. The format can be changed in the MiniCalendars worksheet. You can also change the calendars to show Monday first or Sunday first.

  • Includes sections for a Prioritized Task List and Daily Expenses.

  • Use the Notes section for grocery lists, journal entries, doodling, etc.

Advertisement

More Daily Planners

There are SO many different types of daily planners! Different sizes, different ways of organizing the information, etc. Here are some helpful links.

 

Like This Template?

Become a Fan

       
"Over the last few months I have needed various types of 'fillable' planners. (Daily, biweekly etc.) and when I Googled, the site that consistently came up with the best ones were yours. This was true for each type of calendar. Today I took some time to look around more and was astounded at all the templates you have there. They are not only extensive and cover many different subjects (from planners, to charts, to menus, to budgets etc), but they are extremely easy to use as well." - Liba