Monthly Calendar in Google Sheets: Create or Download

To make a monthly calendar in Google Sheets, enter a date from the month in a cell such as B1, then create a seven-column grid of dates with a formula or start from a template in the Sheets template gallery. A formula-based calendar updates when you change B1; a template is quicker if you mainly need a ready-made layout.

What a Google Sheets monthly calendar can do

A calendar in a spreadsheet is useful when you want dates and plans beside information that is already organized in rows and columns. You can use one to track appointments, deadlines, staff shifts, school activities, content schedules, or household tasks. Unlike a dedicated calendar app, a sheet can be reshaped to include extra columns for owners, status, location, or budget.

There are two common approaches. A template gives you a preformatted calendar that you can adapt, while a formula-built calendar calculates the dates for whatever month you select. A basic date grid does not automatically import events from Google Calendar. Events must be entered into the sheet, connected through a separate workflow, or managed in Google Calendar itself.

Google Sheets runs in a web browser and saves changes to Google Drive. People with access can collaborate on the same calendar, subject to the sharing permissions you set. That makes it convenient for group planning, although it is still important to decide who can edit dates and who should only view them.

Choose a template or build your own

For a quick start, open Google Sheets and choose Template gallery on the Sheets home screen. Look for a calendar or schedule template, open it, and replace its sample content. The exact template selection can change over time, and not every template has the same layout or features. Before entering a lot of information, check whether the template covers one month, a full year, or a different planning period.

A custom calendar is a better choice when you want a specific week start, a compact print layout, or extra space for notes. It also makes the date logic visible, which is helpful when you want to reuse the same sheet each month. You can build a simple calendar with a date grid, weekday headings, and a cell for the month selector; additional event tracking can be added separately.

Choose a template if appearance and speed matter more than changing the underlying layout.
Build a formula calendar if you need to reuse it, control the week start, or understand how dates are calculated.
Use Google Calendar instead if reminders, invitations, and automatic event notifications are the main requirements.

Create a date grid with a formula

Start with a blank sheet. Put a real date from the month you want to display in B1; for example, enter June 1, 2026. The value needs to be a date, not text that only looks like one. In A3:G3, type the weekday headings Sunday through Saturday. Select A4 and enter the following formula. It creates a six-row by seven-column grid, beginning on the Sunday on or before the first day of the selected month.

Assumption: B1 contains a valid date in the desired month, and A4 is the upper-left cell of an otherwise empty 6-by-7 calendar grid. In Google Sheets, enter:

=DATE(YEAR($B$1),MONTH($B$1),1)-WEEKDAY(DATE(YEAR($B$1),MONTH($B$1),1),1)+1+SEQUENCE(6,7,0,1)

Sheets expands the result across A4:G9. The first part finds the first day of the month, and WEEKDAY with the return type 1 treats Sunday as the first day of the week. The final term adds a sequence of 42 consecutive numbers, so every calendar cell receives the next date. A six-week grid accommodates months that span parts of six calendar weeks; some months need only five visible rows.

To make Monday the first day of the week, change the weekday headings to Monday through Sunday and use this version instead. It uses WEEKDAY’s return type 2, where Monday is day one.

Assumption: B1 contains a valid date, and A4 is the top-left cell of the empty 6-by-7 grid. For a Monday-first calendar, enter:

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

Change B1 to another date to display another month. For example, changing it from June 1, 2026 to July 1, 2026 recalculates the grid for July. If you want the year and month displayed as a heading, select a heading cell and use Format > Number > Custom date and time to choose a month-and-year display. The heading cell can reference B1, so it changes with the selected month.

Format dates and distinguish other months

The grid contains full date values, even if you choose to show only the day number. Select A4:G9 and use Format > Number to choose a date display, or use Format > Number > Custom date and time to show a compact day format. Changing the display format does not remove the year or month stored in each date, which is why the calendar can calculate correctly across December and January.

The first and last rows may include dates that belong to the previous or following month. They are not errors: they fill the weeks around the selected month. To make them less prominent, select A4:G9, open Format > Conditional formatting, choose Custom formula is, and use the following rule. Set the rule’s apply-to range to A4:G9.

Assumption: the calendar date values are in A4:G9 and B1 contains a date in the month being shown. In the conditional-formatting custom formula field, enter:

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

Choose a muted text color for the rule. Because the reference to A4 is relative, Sheets evaluates the corresponding cell throughout the range; the reference to B1 is fixed. You can add another conditional-formatting rule to shade weekends, but put the relevant formula against the same top-left cell and apply it to A4:G9. A simple example is =WEEKDAY(A4,2)>5, which identifies Saturday and Sunday when the range contains dates.

For readability, widen columns A:G and increase the height of rows 4:9 to leave room for notes. Use borders to separate weeks, align dates at the top of each cell, and turn on text wrapping if you plan to type short event labels into the date cells. Keep the weekday names in their own row so the calendar remains understandable when printed.

Add events without losing the date structure

For occasional plans, type a short label directly into the appropriate date cell. This is simple, but it mixes the date grid with event details and can make formulas or sorting less useful. If several events can fall on one day, or you need to search by person or category, keep events in a separate table instead. For example, use columns I and J for Event date and Event, with one event per row. You can add columns for time, owner, location, or status as needed.

Keeping one event per row makes it easier to filter and sort the list, and it avoids forcing several appointments into one calendar cell. Make sure the event-date column contains real date values, not text. If a calendar is shared, agree on a consistent way to enter times and names; otherwise, people may interpret a short label differently or create duplicate entries.

A date grid alone does not turn a spreadsheet into a reminder system. Google Sheets does not automatically create Google Calendar notifications just because a date appears in a cell. If reminders and invitations are essential, use Google Calendar for those functions and treat the spreadsheet as a planning or reporting view. Connecting the two may require an add-on, an automation service, or a custom integration, each with its own permissions and setup.

Share, collaborate, and print

Use the Share button to invite specific people or manage link access. Give edit access only to people who need to change the calendar; viewers can read it without altering entries. In a shared sheet, edits are saved as collaborators work, and version history can help identify or restore earlier changes. Avoid putting sensitive personal details in a broadly shared calendar, and check the sharing settings rather than assuming that a link is private.

To print the calendar, choose File > Print. In the print settings, review the selected sheet or cell range, paper size, orientation, margins, and scale. A seven-column calendar often fits more comfortably in landscape orientation, but the result depends on the font, row heights, and printer settings. Use the print preview to check that the month heading and weekday labels appear on the same page as the dates. If the calendar is too small, reduce decorative formatting or print only the calendar range.

Printing is a snapshot: changes made afterward in Sheets do not update a page already printed. For an up-to-date shared plan, use the sheet itself or print a fresh copy when needed. You can also download or export the sheet from the File menu if you need a copy in another format, but check the exported layout because formatting and page breaks may differ.

Costs and practical limitations

Google Sheets is available for personal use with a Google account, while organizations may provide it through a Google Workspace plan. Workspace subscriptions can have costs and features that vary by plan and organization. A basic monthly calendar does not require a paid calendar template: a blank sheet and the date formula are enough. Some third-party templates, add-ons, or integrations may charge separately, so review their terms and requested permissions before using them.

Sheets is flexible, but a hand-built calendar requires maintenance. Someone has to enter or update events, manage access, and check the layout. It does not provide all the dedicated scheduling features of a calendar application, such as event invitations and built-in notifications. On the other hand, a spreadsheet can combine calendar dates with structured details or calculations that a standard month view may not show.

Common problems and fixes

The formula shows an error or will not expand: confirm that B1 is a valid date and that A4:G9 is empty. The SEQUENCE result needs room to spill into all 42 cells; existing values or merged cells in that area can block it.
Dates appear as large numbers: the cells still contain date serial values, but their display format is not set to a date. Select the grid and choose a date format from Format > Number.
The month looks shifted by a day: check that the weekday headings match the formula’s week-start setting. The Sunday-first formula uses WEEKDAY return type 1; the Monday-first version uses return type 2.
Dates from a neighboring month are visible: this is expected in a full-week grid. Use conditional formatting to fade them, or use a template with a different layout if you do not want adjacent-month dates shown.
The calendar displays an unexpected month: verify that B1 is a date value and includes the intended year. A date such as March 1 in different years produces different weekday positions.
Text does not fit in a cell: increase the row height, widen the columns, or turn on text wrapping. If entries are numerous, store them in a separate event table instead of crowding the date grid.

Frequently Asked Questions

Does Google Sheets have a monthly calendar template?

Yes. The Sheets home screen has a Template gallery, where calendar or schedule templates may be available. The selection can change, so inspect a template’s date range and layout before using it. You can also create a reusable calendar in a blank sheet.

How do I make a calendar start on Monday?

Use Monday-to-Sunday headings and the Monday-first formula shown above, which uses WEEKDAY with return type 2. The headings and formula must agree; otherwise, the dates will appear under the wrong weekday names.

Can Google Sheets automatically add my Google Calendar events?

Not by default. A date grid in Sheets does not automatically import Google Calendar events or send calendar reminders. A separate integration or automation may be possible, but it needs its own setup and permissions.

Why does my calendar show days from the previous month?

The formula creates complete weeks, so the first row may begin before the first of the month and the final row may extend into the next month. Those dates make the weekday columns line up. Conditional formatting can fade dates outside the selected month.

Can more than one person edit a Sheets calendar?

Yes. Share the file and assign appropriate access, such as editor or viewer. For group use, keep event details consistent and limit editing permissions to people who should change the schedule.

Can I print a calendar made in Google Sheets?

Yes. Choose File > Print, then review the range, orientation, margins, and scale in the print settings. Preview the page before printing to make sure the month heading, weekday labels, and full date grid fit.

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.