1
Click cell A1
Click cell A1 in an empty sheet.
How to create a Calendar in Google Sheets
Build a monthly calendar: a row of weekdays, one SEQUENCE formula for the dates, and a number format that shows just the day.
Operations
2
Type the month
Type the month and year as a title.
3
Press Enter
Press Enter to confirm.
4
Type the weekdays
In row 2, type the days of the week, pressing Tab after each one and Enter after the last.
5
Type the date formula
In A3, type =SEQUENCE(5,7,DATE(2026,9,27)). It fills 5 weeks of 7 days, starting with the Sunday before the 1st.
6
Press Enter
Press Enter to confirm.
7
Select the dates
Highlight the cells the formula filled.
8
Click Format
Open the Format menu.
9
Click Number
Hover over Number to open its submenu.
10
Click Custom number format
Choose Custom number format at the bottom of the list.
11
Click the format box
Click the box at the top of the window.
12
Type d
Type d so each cell shows only the day of the month.
13
Click Apply
Click Apply to format the selected cells.
14
Calendar created
Each week is a row, with the weekdays as headers. Bold the title or add colors to finish it.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.