Loading
  • Home

  • Productivity

  • App tips

App tips

3 min read

How to make a calendar in Google Sheets

By Dylan Reber · June 13, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

Calendar apps are great, and there are a ton of options out there. But maybe you're one of those people who insist on using Google Sheets for everything. I can see the appeal: it's free, fully customizable, and you can share your Sheets calendar with anyone (or everyone) using a link. So, how do you make a calendar in a spreadsheet?

Here's the quick version of how to create a calendar in Google Sheets:

  1. Create a blank spreadsheet in Google Sheets.

  2. In the A1 cell, type the month and year (e.g., January 2024). 

  3. Highlight cells A1 through G1, and click Merge cells.

  4. In the second row, fill in the days of the week.

  5. Below, fill in the numbers for every day in the month.

  6. Add more rows, and reformat as needed.

Keep reading for a more detailed guide with visual examples, or skip straight to the Google Sheets calendar template.

Table of contents:

  • How to make a calendar in Google Sheets

  • How to create a calendar using a Google Sheets template

  • Automate Google Sheets

How to make a calendar in Google Sheets

Creating a calendar in Google Sheets is daunting when you're staring at a blank spreadsheet, but it's actually pretty simple. Here's how:

  1. Open Google Sheets, and select Blank spreadsheet

  2. In the first cell (typically A1), enter a month and year (e.g., January 2024.)

  3. Highlight cells A1 through G1 and click the Merge cells button.

    Screenshot of merge cells feature in Google Sheets
  4. Center the text in this row using the Horizontal align tool.

    Screenshot showing how to center text in Google Sheets.
  5. In the second row (cells A2 to G2), enter the days of the week from Sunday to Saturday. For a shortcut, just type Sunday, and drag the cell selector all the way to cell G2. The remaining days of the week will be autofilled.

    Screenshot of the days of the week typed into Google Sheets.
  6. In the third row, enter the number 1 under the day your month starts on. For example, January 2024 started on a Monday, so I typed 1 in cell B3.

  7. Fill in the rest of the dates. You can do this manually or use a formula to speed up the process. (Because my start date is in cell B3, I'll enter the formula =B3+1 in the next cell, hit enter, and then drag the cell selector to the end of the row to autofill that week's dates.)

    Screenshot showing filled in calendar dates on Google Sheets.
  8. Add new rows between each week by right-clicking and selecting Insert 1 row above

  9. Resize rows to your liking. Your calendar should look something like this.

    Screenshot showing resized cells on Google Sheets calendar.
  10. Using the toolbar, adjust font, font size, fill color, and text formatting as needed to improve readability. 

    Screenshot showing a designed calendar in Google Sheets.
  11. Right-click the sheet tab at the bottom, and select Duplicate to create sheets for the remaining months. 

    Screenshot showing how to duplicate tabs in Google Sheets.
  12. Rename each sheet with its corresponding month by right-clicking the sheet name and selecting Rename.

  13. For each remaining month, update the title cell (A1), then reformat based on the number of days each month has and which weekday it starts on.

  14. Type events directly into the cells.

    Screenshot showing how to enter events into a Google Sheets calendar.

Now you have a working calendar in Google Sheets you can fill in with events, holidays, product launches, blackout dates, and more. If you want to give your most trusted colleagues access, hit the Share button in the top-right corner, and send them a link.

Read more: 7 marketing calendar templates to boost your strategy

How to create a calendar using a Google Sheets template

If you want to skip all these steps, you can also just use Google's official "Annual Calendar" Sheets template. Here's how to set it up.

  1. Open Google Sheets, and click Template gallery at the top of the page.

    Screenshot showing the template gallery in Google Sheets.
  2. Scroll down to the section labeled Personal, and select Annual Calendar. This template will autopopulate Sheets with a calendar for the current year. 

    Screenshot showing where to select the Annual Calendar template in Google Sheets.
  3. Click the tabs at the bottom to select a month and begin filling out your calendar.

    Screenshot showing how to select a month on a Google Sheets calendar template.
  4. To change your theme, select Format > Theme. You can select one of Google's premade themes or customize your own.

    Screenshot showing theme select in Google Sheets.

This official template is the fastest way to create a calendar directly in Google Sheets, with no formulas or formatting required.

Looking for another template? We've got one with an extra tab to help organize your events—and in case Google decides to get rid of theirs—for 2024 and 2025.

Automate Google Sheets

Building a calendar in Google Sheets is a great way to impress your less spreadsheet-savvy coworkers, but you can do a whole lot more with Zapier's Google Sheets integrations. Zapier connects Sheets with thousands of other apps, giving you access to time-saving automations and freeing up your schedule for the tasks that matter most.

Learn more about how to automate Google Sheets, or check out one of these premade templates below.

Save new Gmail emails matching certain traits to a Google Spreadsheet

Save new Gmail emails matching certain traits to a Google Spreadsheet
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets
  • Facebook Lead Ads logo
  • Google Sheets logo
Facebook Lead Ads + Google Sheets

Send emails via Gmail when Google Sheets rows are updated

Send emails via Gmail when Google Sheets rows are updated
  • Google Sheets logo
  • Gmail logo
Google Sheets + Gmail

Zapier is a no-code automation tool that lets you connect your apps into automated workflows, so that every person and every business can move forward at growth speed. Learn more about how it works.

Related reading:

  • The best Google Sheets add-ons to boost your productivity

  • How to create detailed Google Calendar events using Zapier

  • How to integrate Google Calendar with your business apps

  • How to integrate Gmail with Google Calendar

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'