Google Sheets Calendar: Create and Customize Your Calendar

To create a calendar in Google Sheets, enter a year and month, then use a date formula to fill a seven-column, six-row grid. Add weekday headings, format the dates, and use conditional formatting to distinguish days outside the selected month; the result can be reused by changing the month and year.

Choose the calendar approach that fits

There are two practical ways to start. A Google Sheets calendar template is the quicker option when a suitable design appears in the Template gallery. Open Google Sheets, choose Template gallery, and look for a calendar or schedule template. The available templates can vary, so if none suits your needs, create a simple monthly calendar yourself. Building the grid gives you control over its layout and avoids relying on a particular template being available.

A spreadsheet calendar works well for a visible monthly overview, team schedules, content plans, classroom dates, and other lists that benefit from rows and columns. It is not the same as Google Calendar: a grid in Sheets does not automatically create calendar events, send reminders, or reserve time. Choose Google Calendar when notifications, invitations, and time-based scheduling are the priority; choose Sheets when you want a customizable table or need to combine dates with other data.

Set up the sheet and its calendar controls

Open a blank Google Sheet in a web browser. Reserve a few cells at the top for controls so you can change the calendar without rebuilding it:

Enter Year in A1 and a four-digit year, such as 2026, in B1.
Enter Month number in A2 and a number from 1 to 12 in B2. For example, 6 means June.
In B3:H3, enter the weekday headings Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday.
Leave B4:H9 empty for the dates. The six rows are enough to show every month, including the days from neighboring months that fill the grid.

You can put the controls elsewhere, but keep the cell references in the formula consistent with their new locations. Using a numeric month is straightforward and avoids ambiguity between month names and date formats. If other people will edit the sheet, label the controls clearly and consider giving the input cells a distinct background color.

Fill the calendar with real dates

With the year in B1, the month number in B2, and the first date cell at B4, enter this formula in B4:

=SEQUENCE(6,7,DATE($B$1,$B$2,1)-WEEKDAY(DATE($B$1,$B$2,1),1)+1,1)

Google Sheets fills a six-row-by-seven-column date grid from that one formula. DATE creates the first day of the chosen month. WEEKDAY with a return type of 1 treats Sunday as the first day of the week; subtracting the appropriate number of days moves the start back to the Sunday on or before the first of the month. SEQUENCE then adds one day at a time across the grid. For June 2026, the first visible date is Sunday, May 31, and June 1 appears under Monday.

The cells contain actual date values, not merely day-number text. That matters because dates can be sorted, compared, and used in formulas. If the formula reports an error or does not fill the grid, confirm that B1 contains a year, B2 is a number from 1 through 12, and B4:H9 are clear. A value in the spill area can prevent the formula from expanding. In some spreadsheet locales, formula argument separators differ; if Sheets rejects the commas, check the spreadsheet locale settings rather than changing the function names.

Format the grid so it reads like a calendar

New date values may initially show as full dates. Select B4:H9 and choose Format > Number > Custom date and time to display only the day number, for example by selecting or entering a day-only format such as d. The underlying values remain dates, even though the cells show only 1, 2, and so on. Make the weekday headings bold, center the dates, and widen the columns so the calendar is easy to scan.

For a usable print or screen layout, increase the height of rows 4 through 9 to leave room for notes, add borders around the date cells, and use a title above the grid that refers to the selected month and year. A merged title is optional; a label in a single cell is easier to maintain if you later add formulas or other controls. Avoid relying on color alone to communicate important information, since readers may print in black and white or have difficulty distinguishing similar shades.

To fade dates that belong to the previous or next month, select B4:H9 and choose Format > Conditional formatting. Set the rule to Custom formula is and use:

=MONTH(B4)<>$B$2

Apply a pale text color or fill. The reference B4 is relative, so the rule evaluates each cell in the selected range; the dollar sign keeps the selected month fixed. This styling is visual only: the neighboring dates remain in the grid and retain their real date values. That can be useful for a continuous weekly view, but you can hide those values with a different design if you want only dates in the selected month to appear.

Add events without breaking the date formula

Do not type event names directly into B4:H9, because those cells are populated by the SEQUENCE formula. Instead, keep event details in a separate list, for example with columns labeled Date, Event, Start time, Owner, and Notes. Enter each event date as a real date, then sort or filter the list as needed. This structure is more dependable than trying to put several appointments into one calendar cell, and it makes the schedule easier to search or reuse.

For a simple personal calendar, you can also add notes or comments to individual date cells, but those are less convenient for sorting, reporting, or managing several events on the same day. A separate event list is especially helpful when you need details such as a location, responsible person, or status. If you want an at-a-glance month view, keep the grid as the overview and the event list as the detailed record.

Sheets will not turn a row in that list into a Google Calendar event automatically just because the date is present. To send invitations or receive reminders, create the event in Google Calendar or use an integration that is appropriate for your account and workflow. Treat the sheet as a planning or tracking tool unless you have deliberately set up a separate connection.

Reuse the calendar for another month

The main advantage of this layout is that you do not have to recreate the dates. Change B2 to another month number, or change B1 for a different year, and the grid recalculates. The weekday headings remain in place, and the conditional-formatting rule continues to identify dates outside the selected month. If you prefer Monday as the first day of the week, change the headings to Monday through Sunday and use a formula that treats Monday as the first weekday:

=SEQUENCE(6,7,DATE($B$1,$B$2,1)-WEEKDAY(DATE($B$1,$B$2,1),2)+1,1)

With the Monday-first version, the formula begins with the Monday on or before the first day of the month. Keep the headings and formula in agreement; otherwise, dates will appear under the wrong weekday. You can make a copy of the sheet before changing its structure, or duplicate a finished monthly tab if you need snapshots of past plans. A single reusable tab is usually simpler when you only need to view one month at a time.

Share, print, and protect the calendar

Sheets lets you share a file with specific people and choose whether they can edit, comment, or only view it. Use the Share button and check the access setting before sending the link; a calendar may contain work schedules, appointments, or other information that should not be public. If collaborators need to change dates or events, decide which cells they should edit and explain the layout so they do not overwrite the formula.

To print, use File > Print and inspect the preview before confirming. A landscape orientation, fit-to-width scaling, and modest margins often help a seven-column calendar fit on a page, though the best settings depend on the amount of event detail. If the printout is too small, print only the calendar area or remove nonessential columns instead of shrinking everything until it is hard to read. Sheets also supports protected sheets and ranges; use Data > Protect sheets and ranges when you want to limit accidental changes to formula cells. Protection is an editing safeguard, not a substitute for sharing the file only with appropriate people.

Common problems and fixes

The formula returns an error: Check that the year and month cells contain valid numbers and that the formula uses the cell references from your layout. Ensure the spill range is empty. If an error points to separators, your locale may require a different argument separator.
Dates show as serial numbers or full dates: Select the grid and use Format > Number to choose a date display, or use a custom day-only format. The display can change without changing the date value.
The dates are under the wrong weekdays: Match the weekday headings to the formula. The Sunday-first version uses WEEKDAY with 1; the Monday-first version uses 2.
Dates from another month appear: That is expected in a complete six-week grid. Use the conditional-formatting rule to fade them, or choose a layout that hides them if you do not want a continuous week view.
Event text disappears or the grid stops updating: Keep the formula output area clear. Move event details to a separate list rather than typing over date cells.

Frequently Asked Questions

Does Google Sheets have a built-in calendar?
Sheets may offer calendar templates in its Template gallery, but a template is still a spreadsheet, not a connected Google Calendar. If you do not see a suitable template, you can build a reusable month grid with the formula above.

Can I make a calendar that starts on Monday?
Yes. Use the Monday-first formula in the reuse section, and change the weekday headings to run Monday through Sunday. The formula and labels must use the same starting day.

Can I put multiple events on one day?
Yes, but it is usually better to list each event on its own row in a separate event table, with a date and any needed details. This avoids crowding the calendar grid and makes the entries easier to filter.

Will changing the month erase my events?
Changing the month and year controls recalculates the date grid, but a separate event list stays as entered. If you type event details into the formula-filled cells, however, you can overwrite the calendar output or block it from expanding.

Can this calendar send reminders?
No. A Sheets date grid does not send Google Calendar notifications by itself. Use Google Calendar for reminders and invitations, or set up a suitable integration if your workflow requires both tools.

Can I use the same formula in Excel?
The formula uses functions available in current Google Sheets and Microsoft Excel versions that support SEQUENCE. Menu names and template options differ between the applications, so follow Google Sheets menu paths when making this sheet in a browser.

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.