How to Add a Calendar in Google Sheets

The simplest way to add a calendar to Google Sheets

You can add a calendar to Google Sheets in three ways: embed a Google Calendar you already own, insert a date picker that lets people click to fill in dates, or build a manual calendar grid using the spreadsheet itself. The method you choose depends on whether you want a working calendar people interact with, a static reference calendar, or just a way to make date entry easier.

The fastest option for most people is the date picker. It takes 30 seconds to set up and works on any cell where you want someone to enter a date. The person clicks the cell, a small calendar pops up, they click the date they want, and it fills in automatically. No formatting, no formulas, no embedded calendars to manage.

Key Takeaways

A date picker is the quickest way to let people enter dates in Google Sheets—click the cell, select from a popup calendar, and the date fills in automatically.
To add a date picker, select a cell, go to Data > Data validation, choose Date, and set your rules (any date, a range, or a specific list).
Embedding a Google Calendar works if you want a reference calendar visible in the sheet, but it requires you to own the calendar and takes up space.
Building a manual calendar grid is useful when you need to mark specific events or availability across weeks or months within the spreadsheet itself.
Date pickers work on desktop and mobile, but embedded calendars display better on larger screens.

How to add a date picker to any cell

A date picker is the most practical calendar tool in Google Sheets. Select the cell or range of cells where you want dates entered. Go to the menu bar and click Data, then Data validation. A panel opens on the right side of the screen.

In the dropdown that says "Choose one," select Date. You now have three options: allow any date, dates within a range, or dates in a specific list. For most uses, "Any date" is fine—people can pick any day from the calendar that pops up. If you want to restrict entries to a specific range (like "only dates in 2024" or "only dates between January 1 and March 31"), choose the second option and enter your start and end dates.

Once you've set your rule, click Done. The cell now shows a small calendar icon. Anyone who clicks that cell will see a popup calendar. They click the month and year at the top to navigate, then click the date they want. The date appears in the cell in the format YYYY-MM-DD by default, though you can change how it displays by formatting the cell as a date.

Embedding a Google Calendar in your sheet

If you want a full calendar visible inside the spreadsheet—not just a date picker, but an actual month view—you can embed a Google Calendar you own. This is useful when you want the sheet to show a team schedule, project timeline, or availability calendar that people can see at a glance.

Open your Google Calendar in another tab and make sure the calendar you want to embed is visible (check the box next to its name in the left sidebar). Right-click the calendar name and select Settings and sharing. Scroll down to "Integrate calendar" and copy the embed code under "Embed this calendar." Go back to your Google Sheet, click Insert in the menu, then Embed. Paste the code and click Embed. The calendar now appears in your sheet.

Keep in mind that embedded calendars take up significant space and display best on desktop screens. Mobile users may see a smaller or scrollable version. Also, the embedded calendar shows only events from the calendar you embedded—it does not let people add events directly from the sheet.

Building a manual calendar grid for event tracking

Sometimes you need a calendar that lives entirely within the spreadsheet, where you can mark specific events, availability, or status for each day. This is common for project timelines, shift schedules, or vacation tracking. You build this manually using rows and columns.

Start by creating column headers for the days of the week (Monday through Sunday). In the rows below, enter the dates for each week. Then fill in the cells with whatever information you need—event names, person names, "Available" or "Booked," colors, or checkmarks. Use conditional formatting to color-code cells based on their content, which makes patterns easier to spot at a glance.

For example, a shift schedule might have employee names in the first column, dates across the top, and "Morning," "Evening," or "Off" in each cell. A project timeline might show task names in the first column, weeks across the top, and colored blocks showing when each task runs. This approach gives you complete control over what the calendar shows and how it looks.

Formatting dates so they display correctly

Google Sheets stores dates as numbers behind the scenes, so how they appear depends on the format you choose. If you add a date picker or type dates manually, they may show as "1/15/2024" or "2024-01-15" depending on your locale and what format the cell is set to.

To change how a date displays, select the cells with dates, click Format in the menu, then Number, then Date or Date time. A list of common formats appears. Choose the one you want—"January 15, 2024" or "15 Jan 2024" or any other style. If none of the presets match what you need, click More formats at the bottom and build a custom format using date codes like YYYY for year, MM for month, and DD for day.

Using formulas to work with calendar dates

Once you have dates in your sheet, you can use formulas to calculate time between dates, count days until a important date, or pull information based on dates. The TODAY() function returns today's date, which is useful for highlighting overdue items or calculating how many days remain until a important date.

For example, =TODAY()-A1 tells you how many days have passed since the date in cell A1. =DATEDIF(A1,B1,"D") calculates the number of days between two dates. =EDATE(A1,3) adds three months to the date in A1. These formulas let you build dynamic calendars and timelines that update automatically.

Choosing the right calendar method for your needs

Use a date picker when you need people to enter dates into specific cells and you want to prevent typos or invalid dates. It is the fastest to set up and works everywhere.

Use an embedded Google Calendar when you want a reference calendar visible in the sheet and you already manage events in Google Calendar. It shows real events but takes up space and does not let people interact with it from the sheet.

Use a manual calendar grid when you need to track events, availability, or status across days or weeks and you want complete control over the layout and colors. It takes more work to set up but gives you flexibility that the other methods do not.

Many sheets use more than one method. A project tracker might have a manual timeline grid for the big picture and date pickers in other columns for people to log when tasks were completed.

Frequently Asked Questions

Can I make a date picker that only allows dates in the future?

Yes. Select the cell, go to Data > Data validation, choose Date, then select "Greater than or equal to" and enter =TODAY() as the date. This prevents anyone from selecting today or any date in the past. You can also set an end date if you want to limit the range.

What happens if someone types a date directly into a cell with a date picker?

They can type a date if the cell allows it, but the date picker icon still appears. If you want to force people to use the picker and reject typed entries, go to Data validation, check the box for "Show warning" or "Reject input," and choose your preference. "Reject input" will not let them save a manually typed date.

Can I embed a calendar that someone else owns?

Only if they have shared it with you and set the sharing permissions to allow embedding. Ask the calendar owner to go to Settings and sharing, scroll to "Integrate calendar," and check whether the embed code is available. If it is not, they may need to change the sharing settings first.

How do I color-code a manual calendar by event type?

Use conditional formatting. Select the cells in your calendar grid, click Format > Conditional formatting, choose "Format rules" > "Custom formula is," and enter a formula that checks the cell content (like =A1="Meeting"). Set the fill color you want, then add more rules for other event types. Each rule applies its color when the condition is true.

Can I sync a Google Sheet calendar with my phone calendar?

Not directly. If you embed a Google Calendar in the sheet, that calendar still syncs to your phone normally—the sheet just displays it. If you build a manual calendar grid in the sheet, you would need to manually add those events to your phone calendar or use a third-party tool to sync them.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.