How to Insert a Calendar in Excel

To insert a calendar in Excel, select File > New, type calendar in the search box for online templates, select a design to preview it, and then select Create. Excel opens the calendar as a new workbook that you can edit, save and print. If you would rather build the calendar inside a workbook you already have, a single SEQUENCE formula can fill in a whole month for you.

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows (the formula method needs Excel 2021 or later). Checked against Microsoft Support on October 7, 2026.

Which calendar method should you use?

Excel has no single “Insert Calendar” button. Instead, there are three practical ways to get a calendar onto a worksheet, and the right one depends on how much control you want and which version of Excel you have.

Method	Best for	Works in	Updates itself?
Calendar template	A finished, good-looking calendar in a minute or two	Excel 2016 and later, with an internet connection	Depends on the template
SEQUENCE formula	A monthly calendar inside your own workbook that changes when you type a new month or year	Excel for Microsoft 365, Excel 2024, Excel 2021	Yes
Manual grid	Any version of Excel, or a one-off calendar you want to lay out by hand	All versions	No

One thing to settle before you start: a calendar grid on a worksheet is not the same as a pop-up calendar that appears when you click a cell. If what you want is a way to choose a date in a cell, see our guide on how to add a date picker in Excel instead.

What you need

• An internet connection for the template method. Microsoft’s template instructions state that a connection is required to find and download templates.
• Excel 2021, Excel 2024 or Excel for Microsoft 365 for the formula method. Microsoft lists the SEQUENCE function for those versions (and for Excel on Mac, iPad, iPhone and Android), but not for Excel 2019 or Excel 2016.
• Nothing extra for the manual method. It uses only basic formatting.

How to insert a calendar from an Excel template

A template is a ready-made workbook with the layout, formatting and often the formulas already in place. This is the fastest route and the one most people should try first.

1. Open Excel and select File > New. Excel shows a page of template thumbnails with a search box above them.
2. Click the box that lets you search for online templates, type calendar, and run the search. Excel lists the calendar templates that Microsoft offers online.
3. Select a template to see a larger preview. Check that it has the layout you need, such as one month per sheet, a whole year on one page, or a week that starts on Monday.
4. Select Create. Excel downloads the template and opens it as a new workbook.
5. Edit the calendar. Type your own events into the day cells and change titles or colors as you like. Many templates include a cell where you choose the year or month; if the template has its own instructions, follow those, because the controls differ from one template to the next.
6. Save the workbook under a name of your own so you can come back to it.

According to Microsoft, calendar templates come in many forms: twelve months in one worksheet or on separate worksheets, thirteen-month school-year calendars, Sunday-to-Saturday or Monday-to-Sunday weeks, and portrait or landscape pages. Some add a notes column, a to-do list or a schedule tracker. It is worth previewing two or three before you pick one.

You can also get a template from Microsoft’s template website. Browse the calendar templates there, select the Download button on the template page, and open the downloaded file in Excel. By default the file lands in your Downloads folder, so Microsoft suggests copying it somewhere you will find it again. The steps are described on Microsoft’s Download free, pre-built templates page.

How to build a calendar that updates itself with SEQUENCE

If you want the calendar on a sheet in your own workbook, and you want it to redraw itself when you change the month, use the SEQUENCE function. SEQUENCE fills a block of cells with a run of numbers. Because Excel stores every date as a serial number (January 1, 1900 is 1, and each later day adds one), a run of numbers that starts on the right day is a calendar. The formula “spills”, which means you type it in one cell and Excel fills the neighboring cells automatically. Microsoft documents the arguments on its SEQUENCE function page.

These steps build a Sunday-to-Saturday month. Use a blank area of a worksheet.

1. In cell A1 type Year, and in B1 type the year you want, for example 2026.
2. In cell A2 type Month, and in B2 type the month as a number from 1 to 12, for example 10 for October.
3. In cells A4 to G4 type the weekday names: Sun, Mon, Tue, Wed, Thu, Fri, Sat.
4. Make sure cells A5 to G10 are empty and not merged. The formula needs that whole block.
5. Select cell A5, type the formula below, and press Enter:
   =SEQUENCE(6,7,DATE(B1,B2,1)-WEEKDAY(DATE(B1,B2,1))+1)
   Excel fills six rows and seven columns. At this point you will see five-digit numbers rather than dates. That is expected.
6. Select cells A5 to G10 and press Ctrl+1 to open the Format Cells dialog.
7. On the Number tab, select Custom in the Category list, type d in the Type box, and select OK. The numbers turn into day numbers from 1 to 31.
8. Change the month in B2 or the year in B1. The whole grid redraws for the new month.

How the formula works

The formula has three parts, and knowing them makes it easy to adjust:

• DATE(B1,B2,1) is the first day of the month you typed.
• WEEKDAY(…) returns that day’s position in the week. With no second argument it counts 1 for Sunday through 7 for Saturday. Subtracting it from the first of the month and adding 1 steps back to the Sunday on or before the 1st.
• SEQUENCE(6,7,start) then counts forward from that Sunday across 6 rows and 7 columns, which is 42 days. Six rows are enough for any month.

A worked example: October 1, 2026 is a Thursday, so WEEKDAY returns 5. The grid therefore starts four days earlier, on Sunday, September 27, and runs to Saturday, November 7. October 1 lands in the Thursday column, exactly where it belongs.

To start the week on Monday instead, type the headers Mon to Sun in row 4 and add ,2 inside the WEEKDAY part, like this: =SEQUENCE(6,7,DATE(B1,B2,1)-WEEKDAY(DATE(B1,B2,1),2)+1). With a return type of 2, WEEKDAY counts 1 for Monday through 7 for Sunday.

Gray out the days from other months

Because the grid always shows 42 days, it includes a few days from the previous and next month. Conditional formatting, which changes how a cell looks based on a rule, can fade them.

1. Select cells A5 to G10.
2. On the Home tab, select Conditional Formatting > Manage Rules, and then select New Rule.
3. Under Select a Rule Type, choose Use a formula to determine which cells to format.
4. In the Format values where this formula is true box, type =MONTH(A5)<>$B$2.
5. Select Format, choose a light gray font color, and select OK until the dialogs close.

To highlight today’s date, add a second rule in the same way with the formula =A5=TODAY() and a fill color of your choice.

Make the calendar always show the current month

Replace the typed values with formulas: enter =YEAR(TODAY()) in B1 and =MONTH(TODAY()) in B2. The TODAY function updates on its own, so the calendar moves to the new month when the date changes.

How to make a calendar manually

The manual method works in every version of Excel. The calendar will not update itself, but you control every cell.

1. Type the month and year in cell A1, for example October 2026.
2. Type the seven weekday names in cells A2 to G2.
3. Type the day numbers in the rows below, starting under the correct weekday. For October 2026, the 1 goes under Thursday.
4. Select columns A to G, right-click the selection, choose Column Width, type a value such as 15, and select OK. (The default width is 8.43.)
5. Select the rows that hold the day numbers, then select Home > Format > Row Height, type a value such as 60, and select OK. Taller rows leave room to type events. (The default height is 15 points; the maximum is 409.)
6. Select the whole grid. On the Home tab, in the Font group, select the arrow next to Borders and choose All Borders.
7. To center the title, select cells A1 to G1 and select Merge & Center. Merge only the title row: when cells are merged, Excel keeps the contents of the upper-left cell only and deletes the rest.

Copy the sheet for the other months

Once one month looks right, reuse it instead of starting over.

1. Right-click the worksheet tab at the bottom of the window and select Move or Copy.
2. Select the Create a copy checkbox.
3. Under Before sheet, choose where the copy should go, and select OK.
4. On the new sheet, change the title and retype the day numbers for the next month. In a SEQUENCE calendar, you only need to change the month number in B2.

As a shortcut, you can hold Ctrl and drag the worksheet tab to a new position to make a copy.

How to print the calendar on one page

1. Select the Page Layout tab.
2. Select Orientation > Landscape. A seven-column calendar fits a wide page better.
3. In the Scale to Fit group, set Width to 1 page and Height to 1 page.
4. Press Ctrl+P to check the preview and print.

Microsoft notes that shrinking a sheet to one page can make it hard to read. If the text comes out tiny, remove empty columns from the print area or reduce the row heights rather than forcing more onto the page. Microsoft’s Scale a worksheet article also describes the Fit to option in the Page Setup dialog, which does the same job.

How to check that it worked, and how to undo it

Pick a date you know and confirm it sits under the right weekday. In a SEQUENCE calendar, change B2 to another month and check again; the 1st should move to a new column. If you select any cell in the grid and switch its format back to a full date with Ctrl+1 > Date, you should see a real date, which proves the cells hold dates and not plain numbers.

To remove a SEQUENCE calendar, delete the formula in cell A5. The rest of the grid is produced by that one formula, so it goes with it. To remove the gray-out rule, select Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells with the grid selected. A template calendar is a separate workbook, so you can simply close it without saving.

Troubleshooting

The grid shows numbers like 46296 instead of days

Those are date serial numbers, which is how Excel stores dates. Select the grid, press Ctrl+1, choose Custom, and type d in the Type box. Use dd if you prefer 01 to 31, or ddd d to show the weekday as well, such as Thu 1.

The formula returns #SPILL!

Something is in the way of the 42 cells the formula needs. Microsoft lists three causes: the spill range is not blank, the range contains merged cells, or the formula is inside an Excel table. Select the cell with the error, open the error alert next to it, and choose Select Obstructing Cells to find what to clear. Unmerge any merged cells in the range, and move the formula outside a table if it is in one.

The SEQUENCE formula does not work at all

SEQUENCE is not available in Excel 2019 or Excel 2016. Use a template or the manual method in those versions.

Cells show #####

The column is too narrow to display the date. Double-click the right edge of the column heading to fit it, or drag the edge wider.

No calendar templates appear under File > New

Online templates need an internet connection, so check that first. On a work or school computer, your organization may manage which templates Excel can reach; in that case, ask your IT team or download a calendar template from Microsoft’s template website in a browser.

Typing over a day breaks the calendar

In a SEQUENCE calendar the day cells are produced by the formula in A5. Typing into any of them blocks the spill and causes #SPILL!. Delete what you typed to restore the grid, and keep your notes in separate cells, for example a taller blank row under each week.

Frequently asked questions

Is there an Insert Calendar button in Excel?

No. Excel does not have a dedicated command for it. You get a calendar by opening a calendar template from File > New, or by building one on a worksheet with a formula or by hand.

Why does my calendar show days from the previous and next month?

The formula always fills six full weeks, so the days before the 1st and after the last day of the month fill the spare cells. Use the gray-out rule above to fade them.

What happens if I type 13 as the month?

Excel’s DATE function rolls extra months into the next year, so 13 with the year 2026 shows January 2027. That makes it easy to step forward with a formula, but for a calendar you read by eye it is clearer to keep the month between 1 and 12 and change the year.

Can I make a full-year calendar?

Yes. Either choose a yearly calendar template, or build one month and copy the sheet eleven times with Move or Copy, changing the month number on each copy.

How do I put today’s date in a cell quickly?

Press Ctrl+; (semicolon) and then Enter to insert today’s date as a fixed value. Type =TODAY() if you want a date that updates every day.

Can I use these calendars in Excel for the web?

Microsoft says you can browse additional calendar templates in Excel for the web. The ribbon steps in this guide describe Excel for Windows.

Once your calendar is in place, a natural next step is to restrict the cells where people type dates so that only valid dates are accepted; our date picker guide covers that with data validation.

Related: How to Make a Gantt Chart in Excel.