How to Insert a Calendar in Google Sheets

To add a pop-up calendar to cells in Google Sheets, select the cells, open Data, Data validation, add a rule set to Is valid date, and click Done. Double-click a cell to open the calendar picker. Pick the date picker for forms and trackers. For planning, Google Sheets can also give you a full monthly calendar layout from a template.

How to Insert a Calendar in Google Sheets

  1. Select the cells where dates will go.
  2. Click Data, then Data validation, then Add rule.
  3. Under Criteria, choose Is valid date.
  4. Click Done.
  5. Double-click any of those cells to open the date picker and choose a date.
  6. For a full calendar, go to File, New, From template gallery and choose Annual calendar, or build your own grid.
Spreadsheet with a date picker calendar open under a date cell
Double-click a date cell to open the picker.

Calendar Options

Option Best for
Date picker (Is valid date) Entering dates in a list
Annual calendar template Printable yearly calendar
Formula-built grid Custom monthly layouts
Dropdown of dates Picking from a fixed set

Build a Monthly Calendar With One Formula

If you want a calendar grid that updates when you change the month, Google Sheets can generate it for you:

  1. In cell A1, type the first day of the month you want, for example 11/1/2026, and format it as a month and year (Format, Number, Custom date and time).
  2. In A2 to G2, type the weekday names Sun, Mon, Tue, Wed, Thu, Fri and Sat.
  3. In A3, enter =SEQUENCE(6, 7, A1-WEEKDAY(A1)+1). This fills a six-week grid starting on the Sunday on or before the 1st.
  4. Select A3:G8 and choose Format, Number, Custom date and time, then set it to show only the day number.
  5. To grey out days from the neighbouring months, open Format, Conditional formatting, choose Custom formula is and enter =MONTH(A3)<>MONTH($A$1), then pick a light grey text colour.

Change the date in A1 and the whole calendar redraws for the new month. Add a row under each week for notes, or widen the rows to make room for events.

Highlight Today and Deadlines

Conditional formatting also works well with date-picker columns. Select your date cells, open Format, Conditional formatting and choose Date is, Today to highlight today’s date, or Date is before, Today to flag overdue items in red. Combined with the date picker, this turns a simple list into a lightweight task tracker.

If the Picker or Template Doesn’t Show Up

  • Picker does not appear: the cell may contain text. Clear it, or enter a real date first.
  • Wrong date format: change File, Settings, Locale, or use Format, Number, Date.
  • Template missing: some work accounts hide templates; make a copy from someone who has one.
  • Related: inserting dates in Google Sheets and auto-filling dates.

Other Questions About Calendars in Sheets

Can I insert today’s date quickly?

Press Ctrl+; for today’s date.

Does the date picker work on phones?

The mobile app shows its own date entry; results vary.

Can I link to Google Calendar?

Not directly without Apps Script or an add-on.