How to Create a Calendar in Excel (Template or Formula) 2026

What you need before you start

The table lists the Excel feature behind each step. Every feature runs in Excel for the web, and only SEQUENCE and FILTER need a newer version.

The version list for SEQUENCE comes from Microsoft's SEQUENCE page, checked on 2026-10-19. Excel for the web is free with a Microsoft account and 5 GB of OneDrive storage, according to Microsoft's free Office page.

How to create a calendar in Excel, step by step

The six steps below build a month calendar that updates itself, then add events and a print layout. Each step ends with a check, so you know it worked.

Step 1: Start from a template or a blank sheet

If you want a finished design, use the template path for your version of Excel. These menu paths come from Microsoft's calendar template guide, checked on 2026-10-19:

Templates are fast, but their layout is fixed. Microsoft warns that template cells which show a date, and blank cells in the date rows, hold formulas. Type over one and the calendar stops updating itself, so add events only in the event areas.

To build your own calendar, choose Blank workbook instead. Right-click the sheet tab at the bottom, choose Rename, and name it after the month.

You are done when you have either a template open or a blank sheet named for your month.

Step 2: Type the month and the weekday headers

In A1, type Month. In B1, type the first day of the month you want, for example 2026-11-01. In D1, add a title that follows B1:

=TEXT(B1,"mmmm yyyy")

In A2, add the weekday names with one formula that spills across A2:G2:

=TEXT(SEQUENCE(1,7,B1-WEEKDAY(B1)+1),"ddd")

You are done when row 2 shows Sun to Sat, and D1 shows the month name and year.

Step 3: Fill the dates with one SEQUENCE formula

Click A3 and enter:

=SEQUENCE(6,7,B1-WEEKDAY(B1)+1)

SEQUENCE makes 6 rows and 7 columns of numbers, starting at the Sunday on or before the 1st and adding 1 each cell. Excel stores dates as numbers, so these are real dates. Select A3:G8, press Ctrl+1 (or right-click and choose Format Cells), choose Custom, and type the format d so each cell shows only the day number.

For a calendar that starts on Monday, use this version and change the headers in Step 2 to match:

=SEQUENCE(6,7,B1-WEEKDAY(B1,2)+1)

Now make the grid look like a calendar: set columns A to G to a width of about 15, rows 3 to 8 to a height of about 60, and align the numbers to the top right.

You are done when the grid shows 42 day numbers, and changing B1 to another month redraws all of them.

Step 4: Gray out days from other months

Select A3:G8. Choose Home > Conditional Formatting > New Rule, pick the rule type that uses a formula, and enter:

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

Set a light gray font. Add a second rule with a bold border or a colored fill to mark today:

=A3=TODAY()

You are done when the leading and trailing days of the next and last months turn gray, and today's date stands out.

Step 5: Add events from a second sheet

Add a sheet named Events with two headers, Date in A1 and Event in B1. Type your events below, one per row, and press Ctrl+T to make it a table named Events.

Date	Event
2026-11-03	Team planning
2026-11-11	Client review
2026-11-11	Dentist
2026-11-26	Office closed

Back on the calendar sheet, select A3:G8 and add a formatting rule with a colored fill that marks busy days:

=COUNTIF(Events!$A$2:$A$200,A3)>0

Conditional formatting rules do not accept table names, so this rule uses a plain range. To list the month's events next to the grid, enter this in I3:

=FILTER(Events[Event],(Events[Date]>=$B$1)*(Events[Date]<EDATE($B$1,1)),"No events")

To see every event on one day, type the date in I1 and use:

=TEXTJOIN(", ",TRUE,FILTER(Events[Event],Events[Date]=I1,""))

You are done when November 11 shows a fill and the list in column I shows the month's four events.

Step 6: Print or share the calendar

Choose Page Layout > Orientation > Landscape, then set Scale to Fit to 1 page wide and 1 page tall. Select A1:G8 and choose Page Layout > Print Area > Set Print Area, then print from File > Print. To share instead, save the workbook to OneDrive and choose Share, so others see the same calendar.

For a full year, duplicate the month sheet 11 times and set each B1 to the next month. On the second sheet, =EDATE(November!B1,1) points B1 at December, and the grid redraws.

You are done when the print preview shows the whole month on one landscape page.

How the calendar redraws itself

Every part of the calendar reads the single date in B1, so the sheet has one input and many outputs. The diagram shows how a change flows through.

Formula reference for Excel calendars

The formulas from the steps, in one place:

More calendar layouts: year, week and work days

The same B1 date and SEQUENCE idea builds three more layouts: a full year on one sheet, a weekly planner with time slots, and a work-day count. Each layout below is one or two formulas. Change the year or the start date, and the layout redraws with no other edits.

A year on one sheet. Type the year in B1, for example 2027. Make 12 month blocks, each 8 rows tall and 7 columns wide, and give each block its own first day with =DATE($B$1,1,1), =DATE($B$1,2,1) and so on. Under each first-day cell, the Step 3 formula fills that month. Twelve blocks fit in 3 rows of 4 on one landscape page.

A weekly planner with time slots. Type a Monday in B1. In B2, =SEQUENCE(1,7,B1) spills the 7 dates across. In A3, =SEQUENCE(10,1,TIME(8,0,0),TIME(1,0,0)) lists 10 hourly slots from 8:00, formatted as h:mm. Type tasks in the grid where a day and a time meet.

WEEKLY PLANNER        Mon 19   Tue 20   Wed 21   Thu 22   Fri 23
  8:00                Email    Email    Email    Email    Email
  9:00                Client   .        Team     .        Review
 10:00                .        Write    .        Write    .
 11:00                .        Write    .        Write    .
 12:00                Lunch    Lunch    Lunch    Lunch    Lunch

Work days in a month. =NETWORKDAYS(B1,EOMONTH(B1,0)) counts the weekdays from the 1st to the last day of the month. Add a list of holiday dates as a third argument, and they drop out of the count. Highlight those holidays on the grid with a rule like =COUNTIF(Holidays!$A$2:$A$30,A3)>0.

Using Excel 2019 or older?

Excel 2019 and older have no SEQUENCE function. Use a template from File > New, or type the dates with simple +1 formulas:

1. Find the weekday of the 1st, and type that date in the matching cell of row 3.
2. In the next cell to the right, enter a formula that adds 1 to the cell on its left, for example =B3+1.
3. Copy that formula across to G3.
4. In A4, enter =G3+1, then copy the row 4 pattern down to row 8.
5. Fill the cells before the 1st in row 3 with =B3-1 style formulas, working right to left.

The conditional formatting rules in Step 4 and the COUNTIF rule in Step 5 work in older versions too.

When a spreadsheet calendar is not enough

A spreadsheet calendar does not remind you or sync with Google Calendar or Outlook. It works well as a printed month or a personal plan. Once a calendar must alert people, move with the work, or show a team's tasks, a calendar view in a task app puts each task on its due date.

In Taskade, the Calendar view is on every plan, and it shows each task of a project on its due date. The Taskade Calendar collects due dates from all your projects in one place. Two-way Google Calendar sync needs a paid workspace. If your events already sit in a sheet, save it as CSV and import it into Taskade.

Turn the calendar into a live app

A calendar can also run as a small app. In Taskade Genesis, one prompt builds a live app with its own database, such as a booking calendar, a content calendar or a shift planner, and Taskade EVE edits it with you in chat. An AI agent can plan the week, and automations with 100+ integrations add events from a form or send a note before a date.

Clone the broker calendar or the content calendar planner from the Taskade App Factory, and share it with a link. The Free plan includes 3 Taskade Genesis apps, 1 AI agent and 2 members, and starts with 0 AI credits. Pro is $10 a month billed annually. Build a calendar app from a prompt

To start from a ready plan, browse the calendar generators or the planning templates. Our AI weekly planner guide and the list of time blocking apps cover the next step up.

Limitations of an Excel calendar

An Excel calendar is a good printed or personal plan with three hard limits:

• No reminders. Excel never sends a notification before a date.
• No calendar sync. Events in the sheet do not reach Google Calendar or Outlook.
• SEQUENCE needs a newer Excel. Excel 2019 and older use the template or typed dates.

Taskade has limits too: Free covers 2 members, two-way Google Calendar sync needs a paid workspace, and Pro is $10 a month billed annually for up to 10 users. See the Taskade plans for the full table.

More guides on spreadsheets and planning

• Track the work behind each date: how to create a to-do list in Excel
• Move tasks across stages: how to create a kanban board in Excel
• Read the history of spreadsheets
• Plan the week ahead with the best AI schedule makers and the best AI study planners
• Learn the time blocking method behind a weekly planner
• Build a booking system when clients pick the dates

Frequently asked questions