Calendar Planner Template in Excel: Build and Use One

How-to basics · Updated November 21, 2026

To make a calendar planner template in Excel, enter a date from the month you want in B1, add weekday headings, and fill a six-row by seven-column grid with dates generated from that month. In Microsoft Excel for Microsoft 365 on Windows, one formula can create the calendar dates; you can then format the grid, add appointments or task details, and print or share the workbook.

What an Excel calendar planner can include

A basic monthly calendar shows the days of the week and the dates in a month. A planner adds useful context, such as appointments, deadlines, priorities, or notes. Excel is flexible: you can make a simple wall-calendar-style grid, or combine a calendar with a list that records more information about each event.

For a reusable monthly template, keep the selected month in one input cell and let the calendar dates update from it. A six-week grid accommodates every month layout, including months that begin late in the week and months that span parts of six calendar weeks. Dates outside the selected month can remain visible in a lighter style, or you can hide them with formatting.

  • Month selector: A real Excel date in a clearly labeled cell, such as B1.
  • Calendar grid: Seven weekday columns and six date rows.
  • Event details: Space for a short appointment, deadline, or reminder.
  • Optional task table: Separate columns for due date, task, owner, status, and priority.

Starting with this structure makes the calendar easier to update than typing every date by hand. It also keeps dates as dates, which matters for sorting, calculations, and conditional formatting.

Build the monthly date grid

  1. Open a blank workbook. In A1, type Month to display; in B1, enter a date within the month you want, such as May 1, 2026. Make sure Excel recognizes it as a date rather than text.
  2. In A3:G3, enter the weekday names from Sunday through Saturday. If your schedule uses Monday as the first day of the week, use Monday through Sunday instead.
  3. Use A4:G9 for the six rows of calendar dates. Select A4, enter the formula below, then copy it across and down through G9.

With the month date in B1 and the calendar grid beginning in A4, enter this formula in A4 and fill A4:G9. It creates a Sunday-first calendar, with the first displayed date being the Sunday on or before the first of the selected month:

=DATE(YEAR($B$1),MONTH($B$1),1)-WEEKDAY(DATE(YEAR($B$1),MONTH($B$1),1),1)+COLUMN()-COLUMN($A$4)+7*(ROW()-ROW($A$4))

For example, May 1, 2026 is a Friday. The first cell of the grid therefore displays April 26, 2026, and the Friday column in that row displays May 1. The final row supplies dates needed to complete the six-week layout. Changing B1 to a date in another month recalculates the grid automatically.

If Monday should be the first weekday, change the headings and use this version in A4, again filling A4:G9. With B1 as the month input and A4 as the top-left grid cell, the formula starts the calendar on the Monday on or before the first day of the month:

=DATE(YEAR($B$1),MONTH($B$1),1)-WEEKDAY(DATE(YEAR($B$1),MONTH($B$1),1),2)+1+COLUMN()-COLUMN($A$4)+7*(ROW()-ROW($A$4))

In both formulas, the dollar signs keep the month input fixed while the formula is copied. The COLUMN and ROW references adjust for each position in the grid. If the dates appear as numbers such as 46138, Excel is showing date serial values with a number format that does not display them as calendar dates; format the cells as dates or as day numbers.

Format dates and make the calendar readable

Give the weekday headings a contrasting fill and bold text. Set the date rows to a consistent height, widen columns enough for short notes, and use borders to distinguish each day. Keep the month input visually distinct so it is clear which cell to change. To show only the day number while retaining a complete date value, select A4:G9 and choose Home > Number Format, then select a date format that displays the day. You can also open Format Cells with Ctrl+1 on Windows; on Mac, use Command+1.

Conditional formatting can distinguish dates from the previous or following month without changing their values. Select A4:G9, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With A4:G9 selected and A4 as the active top-left cell, enter this rule and choose a muted font color or fill:

=MONTH(A4)<>MONTH($B$1)

The rule compares each calendar date with the month in B1. If you prefer to leave the outside dates visible but deemphasized, this is usually clearer than removing them. You can add another rule to highlight the current date. For that rule, with A4:G9 selected and A4 as the active cell, use:

=A4=TODAY()

Conditional formatting changes appearance, not the underlying date. If the highlight does not appear, check that the grid contains real dates, that the selected range begins at A4, and that the formula uses the correct month-input cell.

Add appointments, reminders, and tasks

There are two common ways to record plans. For a personal calendar with a few events, type short notes in the cells beside the date numbers. Increase row height and turn on Wrap Text through Home > Wrap Text if descriptions need more than one line. A cell can contain multiple lines; press Alt+Enter on Windows to start a new line while editing it. On Mac, the line-break shortcut differs by keyboard and Excel version, so use the Insert Line Break command available while editing if Alt+Enter does not work.

For a busier schedule, keep event details in a separate table rather than squeezing them into the calendar. Useful columns include Date, Start time, Event, Location, Owner, and Status. Select the range and choose Insert > Table to make the list easier to filter and extend. A table is particularly useful when several events fall on the same day, when you need to sort by owner, or when you want to filter to open tasks.

Use a consistent status vocabulary such as Not started, In progress, and Done. If several people edit the workbook, agree on date and time conventions—for example, whether times use a 12-hour or 24-hour clock—and avoid relying on color alone to convey status. A written label remains understandable when the workbook is printed in grayscale or viewed by someone with color-vision differences.

Choose a layout for your planning needs

The best calendar template depends on what you are planning. A personal month view works well for appointments and family commitments. A project planner may need a task table with due dates, owners, dependencies, and progress. A shift or staffing calendar may need names in rows and dates in columns, while a content calendar may track channel, draft status, publication time, and a link to the final material.

  • Monthly grid: Easy to scan and print; best for high-level plans and a limited number of notes per day.
  • Weekly planner: Gives more room for time blocks and detailed daily tasks, but covers less time on one page.
  • Event table: Handles many entries and filtering well; less visually calendar-like unless paired with a monthly view.
  • Combined workbook: Uses a calendar for overview and a table for detailed records; helpful when the same plan needs both views.

For a team calendar, also consider ownership and editing. A workbook stored in a shared Microsoft 365 location can support collaboration when the file format, permissions, and organizational settings allow it. A locally saved copy may not show other people’s latest changes. Clarify who maintains the file, whether people may edit events directly, and how conflicts or cancellations are recorded.

Print, share, and maintain the workbook

Before printing, check the page layout rather than assuming the grid will fit neatly. Choose Page Layout > Orientation > Landscape if the calendar is wider than it is tall. Use Page Layout > Print Area > Set Print Area after selecting the cells you want on paper, and inspect File > Print for the preview. Scaling to fit one page can make small text difficult to read, so adjust column widths, margins, or paper size before shrinking the whole sheet. Ctrl+P opens the print screen on Windows; Command+P is the Mac shortcut.

For a digital handoff, save the workbook as an Excel workbook (.xlsx) if recipients need to edit it. A PDF is more suitable when the recipient only needs a fixed, printable view, but it will not behave like a working calendar. Give the file a name that identifies its period or purpose, and update the month input before exporting a new monthly PDF. If the workbook contains private appointments or staff information, check the destination and sharing permissions before sending it.

Common problems and practical fixes

  • Dates do not update: Confirm that B1 contains an Excel date and that the formula references $B$1. If B1 contains a month name typed as text, replace it with a date.
  • The grid starts on the wrong weekday: Match the formula’s WEEKDAY setting to the headings. The first formula uses Sunday-first numbering; the alternate formula uses Monday-first numbering.
  • Dates show as serial numbers: Apply a date format to A4:G9. The underlying values can still be correct even when their display format is not.
  • Notes disappear in the cell: Widen the column, increase row height, or use Wrap Text. For several events on one date, a separate event table is generally easier to maintain.
  • The calendar prints across several pages: Set a print area, review landscape orientation, and check the print preview. Avoid scaling so far down that dates and notes become unreadable.

A calendar grid is an overview, not a complete scheduling system. It does not automatically prevent two events from being booked at the same time, send reminders, or keep a team’s availability synchronized with everyone’s calendars. If those functions matter, use Excel as a planning or reporting aid alongside a calendar service designed for shared availability and notifications.

Frequently Asked Questions

Does Excel have a calendar planner template?
Excel may offer templates through its workbook template gallery, with available choices depending on your Microsoft 365 setup and current template catalog. You can also build a reusable monthly planner using a date input, weekday headings, and a six-row grid as described above.

How do I change the month in an Excel calendar?
Enter a different valid date within the desired month in the month-input cell, B1 in this example. The formula-generated dates update from that date. The day of the month entered does not have to be the first; using the first makes the input easier to recognize.

Can an Excel calendar show Monday as the first day?
Yes. Change the weekday headings to Monday through Sunday and use the Monday-first formula in the date-grid section. The headings and formula must agree, or the dates will appear beneath the wrong weekday labels.

Can I put multiple appointments on one date?
Yes, but a single calendar cell can become crowded. For several appointments, record each one as a separate row in an event table with a date and time, then use the month grid as a high-level reference.

Can I use this calendar in Excel for the web or on Mac?
The basic date formula and cell layout work in current Excel for the web and Excel for Mac, although ribbon locations and some keyboard shortcuts can differ. The steps above use Excel for Microsoft 365 on Windows; on Mac, use Command+1 instead of Ctrl+1 to open Format Cells.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.