Google Sheets Calendar: Create and Customize a Month View

Create a calendar view in Google Sheets by entering the first day of a month in cell B1, then placing a formula in A4 to generate a six-week date grid. With B1 holding a real date such as January 1, 2026, use =SEQUENCE(6,7,$B$1-WEEKDAY($B$1,2)+1,1) in A4; it fills A4:G9 with dates for a Monday-start calendar. Format the cells to show day numbers, add conditional formatting, and keep event details in a separate list if you want the calendar to update reliably.

What a calendar view in Sheets can do

A calendar made in Sheets is a date grid inside a spreadsheet, not a separate interactive calendar application. It is useful for planning editorial deadlines, staff coverage, class assignments, project milestones, or personal tasks when you also want to sort, filter, calculate, and share the underlying data. You control the layout and can tailor it to a particular month or workflow.

Google Sheets does not offer a single, built-in monthly calendar view that automatically turns any table of events into a Google Calendar-style display. A formatted date grid is a practical workaround. Sheets also has a Timeline view for supported date-based project data, but that is a different presentation and is not a conventional month-by-month calendar. Template Gallery files can provide a starting point, though available templates and their layouts may change.

Decide whether you need a blank planning calendar or a calendar connected to an event list. A blank grid is quick to build and easy to print. A connected setup keeps event records in rows and can show dates or event counts in the grid, but it takes more planning and does not automatically reproduce every Google Calendar feature.

Build a reusable monthly date grid

Open a new or existing spreadsheet in Google Sheets in a web browser. Put a month label such as Month in A1 and enter the first date of the month in B1. For example, enter January 1, 2026, as a date value, not as text. You can use the date picker or type a recognizable date and check that Sheets interprets it as a date.
In A3:G3, enter weekday headings Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. Put the formula below in A4. The assumed layout is the first day of the chosen month in B1, weekdays in A3:G3, and an empty six-by-seven grid beginning at A4. The formula returns 42 consecutive dates, starting with the Monday on or before the first of the month.

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

For January 2026, the result starts on Monday, December 29, 2025, because January 1 falls on a Thursday. The last row runs through Sunday, February 8. Showing a few days from the previous and following months is normal: the six rows keep the calendar shape consistent. Changing B1 to the first date of another month recalculates the grid automatically.

SEQUENCE spills its results into the cells to the right and below A4. Keep A4:G9 clear so the formula can expand; existing values or merged cells in that area can cause an expansion error. If your spreadsheet locale uses semicolons as formula separators, Sheets may require semicolons instead of commas. The formula uses Google Sheets functions and syntax, not an Excel-only feature.

Format dates and make the month easy to read

The grid initially displays full date values. To show only the day number while preserving each cell as a usable date, select A4:G9 and choose Format > Number > Custom date and time. Choose or enter a day-only format, such as a day number, and apply it. Avoid replacing the dates with typed text such as 1, 2, and 3: actual dates are needed for sorting, comparisons, and conditional formatting.

Improve legibility with a wider column size, taller rows, centered weekday headings, borders, and a contrasting fill for the heading row. Freeze the weekday headings if you expect to scroll: select the row below the headings and use View > Freeze. For a compact printout, use File > Print to adjust page orientation, scale, and margins, then review the print preview before printing. The exact controls shown in the print panel can depend on the browser and printer.

Use conditional formatting to distinguish dates outside the selected month. With B1 containing the month date and A4:G9 containing the calendar, select A4:G9, choose Format > Conditional formatting, set the rule to Custom formula is, and use =MONTH(A4)<>MONTH($B$1). Apply a muted text color or fill. The reference to A4 is relative, so the rule evaluates each cell in the selected range; the dollar signs keep the month reference fixed.

To highlight today, add another conditional-formatting rule to the same range. With the same cell layout, use =A4=TODAY() as the custom formula and choose a distinctive style. TODAY updates with the current date when the spreadsheet recalculates. If you use several rules on the same range, review their order and styles so one rule does not visually obscure another.

Keep event information in a separate table

For anything beyond a simple blank planner, create a second sheet named Events. Add columns such as Date, Event, Start time, Owner, and Notes, with one event per row. Keep the Date column as actual date values. Separate rows make it much easier to filter a person’s tasks, sort by date, add new events, or find duplicate entries than placing multiple unrelated details in one calendar cell.

You can use a count beside a calendar date to show how many events are scheduled for that day. With event dates in Events!A2:A and a calendar date in A4, enter =COUNTIF(Events!$A$2:$A,A4) in a separate helper cell; it returns the number of exact date matches. For example, if two rows in the Events sheet have the date shown in A4, the result is 2. This counts events but does not display their names. Keep event dates free of time values for this exact-match approach, because a date-time value may not equal a date-only calendar cell.

To inspect the actual event details, filter the Events table by date or use a filter view for a particular person or category. If you manually type event names into the monthly grid, remember that those entries will not move automatically when you change the month date. A separate event table is therefore a better source of truth; treat the month grid as a visual aid rather than the only place where important information is stored.

Choose the setup that fits your planning needs

Blank monthly calendar: Use the date grid alone for a printable overview or a simple month planner. It is the least complicated option, but event text and month navigation need to be handled manually.
Calendar plus event table: Use this when events need owners, notes, categories, or filtering. The table preserves structured information, while the grid gives a quick visual overview. Counts are straightforward; displaying several event titles inside each date cell requires more elaborate formulas or a different layout.
Google Sheets template: Check the Template Gallery if you want a preformatted planner. Inspect its formulas and date behavior before relying on it, since a template may be designed for a specific year, week start, or planning style.
Google Calendar: Prefer Google Calendar when you need reminders, invitations, recurring events, availability, or a day/week/month interface built around appointments. Sheets is stronger for tabular analysis and custom tracking; it is not a drop-in replacement for those calendar tools.

For a team, agree on one date format and one convention for week starts. Also decide who can edit the event table. Google Sheets sharing permissions apply to the spreadsheet, so someone with edit access may be able to change both the calendar and its data unless you protect ranges or otherwise manage access.

Common date and formula problems

If the formula displays an error, first check that B1 contains a valid date and that A4:G9 is empty. A date that looks correct but is stored as text may not behave as a date. Re-enter it using a recognized date format, or check the spreadsheet’s locale under File > Settings; locale affects date interpretation and can also affect formula separators.

If the calendar starts on the wrong weekday, check the weekday headings and the second argument in WEEKDAY. In the provided formula, WEEKDAY(date,2) numbers Monday as 1 and Sunday as 7, so the grid begins on Monday. For a Sunday-start layout, change the headings to Sunday through Saturday and use =SEQUENCE(6,7,$B$1-WEEKDAY($B$1,1)+1,1) in A4. This version assumes the same B1 and A4:G9 layout, but WEEKDAY with 1 numbers Sunday as 1.

If dates from another month appear in a row, that is expected, not a formula mistake. The grid needs those dates to complete whole weeks. Use the conditional-formatting rule to fade them, or leave them visible if your planning crosses month boundaries. If the displayed date appears as a serial number or with a time, adjust the number format rather than changing the underlying formula.

If a formula separator error appears, your locale may expect semicolons. If a conditional format colors every cell or none of them, confirm that the rule applies to A4:G9 and that its custom formula begins with A4, the top-left cell of that range. For copied templates, check whether formulas point to the correct month selector and whether the intended cells are protected or merged.

Frequently Asked Questions

Does Google Sheets have a built-in calendar view?

Sheets can show calendar templates and date-based views such as Timeline, but it does not provide a standard interactive monthly calendar view that automatically converts any event table into a Google Calendar-style month. A formula-driven date grid is a common way to create that layout.

How do I make the calendar start on Sunday?

Put Sunday through Saturday in the weekday heading row and use the Sunday-start SEQUENCE formula above. Its WEEKDAY argument of 1 treats Sunday as the first day of the week; the Monday-start version uses 2.

Can I put multiple events in one calendar date?

Yes, but a plain date grid does not automatically collect event titles from a separate table. You can type several items into a cell manually, or build a more advanced formula-based display. For dependable filtering and editing, store each event as its own row and use the grid as an overview.

How do I change the calendar to another month?

Replace the date in B1 with the first day of the month you want. The SEQUENCE formula recalculates the dates. If you want a month label, format B1 to show a month and year, or enter a separate label; avoid changing B1 to text if the date grid formula depends on it.

Can I sync this calendar with Google Calendar?

A spreadsheet date grid does not automatically sync with Google Calendar. Google Calendar and Sheets can be used together through available import, export, or automation options, but those workflows have their own requirements and may not keep every change synchronized. Use Google Calendar itself for invitations and reminders.

Make the calendar maintainable

A useful Sheets calendar starts with real date values, a clearly identified month selector, and a consistent weekday order. The six-by-seven grid is easy to reuse, while conditional formatting clarifies which dates belong to the selected month and which date is today. For richer planning, keep event records in a separate table and choose whether the grid needs to show dates, event counts, or manually entered notes.

Before sharing the file, test a short month and a month that begins late in the week, check the printed page, and confirm that collaborators understand where to add events. These small checks catch common issues such as text-formatted dates, a mismatched week start, or event details stored only in the visual grid.

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.