Excel Blank Calendar Template: How to Get One

How-to basics · Updated November 22, 2026

The quickest way to get a blank calendar template in Excel is to open Excel, go to File > New, type “calendar” in the search box, and choose a template from the gallery. If you prefer a truly empty grid you can format yourself, you can also build one in about two minutes using the DATE function and a simple grid — both methods are covered below.

Why Use a Blank Calendar Template in Excel?

A blank calendar template gives you a month-at-a-glance view that you can customize for planning, scheduling, or tracking. Unlike a pre-filled calendar app, an Excel calendar is fully editable: you can change colors, add notes, insert rows for tasks, or print it on a specific paper size. Many people use them for editorial calendars, content planning, classroom schedules, or family activity tracking. The template is a starting point — you are not locked into any layout or data structure.

How to Find the Built-In Calendar Templates

Microsoft Excel for Microsoft 365 (Windows) includes a set of calendar templates in the New screen. Here’s the exact path:

  1. Open Excel and click File > New.
  2. In the search box, type “calendar” and press Enter.
  3. Browse the results. You’ll see options like “Photo calendar,” “Any year calendar,” “Monthly calendar,” and “School calendar.”
  4. Click a thumbnail to preview it, then click Create.

On a Mac, the path is the same: File > New from Template… (or File &bgt; New in newer versions) and then search for “calendar.” Excel for the web also has a template gallery — go to File > New and search. Note that some templates are for specific years (e.g., 2025) and may not update automatically; others are “any year” and let you change the year in a cell.

How to Create a Blank Calendar from Scratch

If you want a completely clean grid with no sample data, building your own is straightforward. Here’s a method that works in Excel 365, Excel 2021, and earlier versions:

  1. In a new worksheet, select cells A1:G1 and type the days of the week (Sun, Mon, Tue, etc.) across the row.
  2. In cell A2, enter the first day of the month as a date, for example =DATE(2025,1,1) for January 1, 2025. Format the cell to show only the day number (Home > Number Format > Custom > d).
  3. In cell B2, enter =A2+1 and drag the fill handle across to G2 to fill the rest of the first week.
  4. In cell A3, enter =G2+1 and drag down and across to fill the remaining weeks. Adjust the number of rows to match the month (most months need 4–6 rows).

This creates a simple grid of dates. To make it look like a calendar, select the range, add borders (Home > Borders), and adjust row heights. For a more advanced version, you can use formulas to automatically display the correct weekday for any month — but for a blank template, the simple method is often enough.

Choosing the Right Template: What to Look For

Not all calendar templates are equal. Consider these factors when picking one:

  • Year flexibility: Some templates are hard-coded to a specific year. Look for “any year” or a cell where you can type the year.
  • Layout: Do you want a full-page monthly view, a week-per-page, or a yearly overview? Choose based on how you plan to use it.
  • Print friendliness: If you plan to print, check the page setup (Page Layout > Print Area) and margins. Some templates are designed for letter-size paper; others may need adjustment.
  • Extra features: Some templates include space for notes, a to-do list, or holidays. Decide if you want those built-in or if you’d rather add them yourself.

If you’re unsure, start with a simple monthly template and customize it. You can always delete extra columns or add your own headers.

Common Problems and How to Fix Them

Users often run into a few issues with calendar templates:

  • Dates don’t update when you change the year. Many templates use formulas that reference a year cell, but some are static. If you change the year and the dates don’t move, check if there’s a cell labeled “Year” and change that instead of editing individual dates.
  • The calendar shows too many or too few rows. Some months need 5 or 6 rows. If your template only has 5 rows, you may need to add a row and copy the formulas down. If it has 6 and you don’t need the last row, you can hide it.
  • Printing cuts off columns. Go to Page Layout > Print Area > Set Print Area to select only the calendar range. Also check Scale to Fit under Page Setup to make it fit on one page.
  • The template has sample data you don’t want. Select the cells with sample text and press Delete, or clear formatting if needed.

Excel Calendar vs. Google Sheets Calendar

If you’re comparing Excel to Google Sheets, the main difference is collaboration and cloud access. Google Sheets has a similar template gallery (open Sheets, click Template Gallery, then “Calendar”), and the files are stored online, making it easy to share and edit with others in real time. Excel, on the other hand, offers more advanced formatting and calculation features, and works offline on your desktop. For a simple blank calendar, both are fine — choose based on where you need to access it and whether you need offline use.

Cost and Safety Considerations

Excel’s built-in calendar templates are free with your Office subscription. There are also many free templates available from third-party websites, but be cautious: some sites may bundle macros or links that could be unsafe. Only download templates from reputable sources, and if a template prompts you to enable macros, make sure you trust the source. Macros can contain harmful code, so it’s safer to stick with the built-in templates or create your own. If you do use a downloaded file, open it in Protected View first (Excel does this automatically for files from the internet) and scan it with your antivirus software.

Frequently Asked Questions

Can I make the calendar show any year automatically? Yes, if you use a template with a year cell, or if you build your own using the DATE function. For example, if you put the year in cell H1, you can use =DATE($H$1,1,1) for January 1. Then the calendar will update when you change the year.

How do I add holidays to my calendar? You can type them directly into the date cells, or use conditional formatting to highlight them. For a list of holidays, you can enter them manually or use a formula to reference a separate list. Excel doesn’t have a built-in holiday list, but you can create your own.

Why does my printed calendar have blank pages? This usually happens because the print area includes extra empty cells. Set the print area to just the calendar range (Page Layout > Print Area > Set Print Area) and check the page breaks under View > Page Break Preview.

Can I use a calendar template in Excel for the web? Yes, Excel for the web has a template gallery. Go to File > New and search for “calendar.” The templates work in the browser, though some advanced features like macros are not available.

Is there a way to make a blank calendar without any formulas? Absolutely. You can simply type the numbers 1, 2, 3, etc. into cells manually. It’s less efficient, but it works if you only need one month. For a reusable template, formulas are better because they save time.

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.