Monthly Schedule in Google Sheets: How to Build One

To make a monthly schedule in Google Sheets, set up a sheet with a year and month, create one row for each day or scheduled item, then add dates, activities, and useful formatting. The result is an editable plan you can reuse, filter, and share. You’ll need a Google account and a web browser; this guide uses Google Sheets in a browser, so some menu names differ from Excel.

What You’ll Need

A Google account with access to Google Sheets.
A list of the activities, appointments, or tasks you want to schedule, including dates and times if known.
Optional: a preferred start day for the week, such as Sunday or Monday, and a list of categories or statuses you want to use.

Step-by-Step

Create a new sheet and name it. Open Google Sheets, choose Blank spreadsheet, and rename the file by clicking the title at the top left. Use a clear name such as “Team Schedule” or “Home Monthly Plan.” At the bottom, rename Sheet1 to the month or to “Schedule.” If you expect to plan several months, use one tab per month or keep one reusable tab and make a copy before changing months.
Choose a layout that fits your schedule. For a practical, editable planner, use a table with one row per scheduled item. In row 1, add a title. In row 2, enter a month label or the month’s first date. In row 4, add headings such as Date, Day, Start, End, Activity, Category, Status, and Notes. Put the headings in A4:H4, leaving row 3 as a spacer. This format is easier to sort and filter than putting several unrelated activities into one cell. If you want a traditional calendar view, create a separate tab for it; the table remains the best place to enter and manage detailed appointments.
Enter the month and dates. You can type each date in column A, starting at A5, or generate a starting set of dates with a formula. For example, enter the year in B2 and the month number in B3 (January is 1, February is 2, and so on). Put this formula in A5, then drag its fill handle down through A35:

=IF(ROW()-4<=DAY(EOMONTH(DATE($B$2,$B$3,1),0)),DATE($B$2,$B$3,ROW()-4),"")

With 2026 in B2 and 2 in B3, the formula returns dates from February 1 through February 28, 2026, followed by blank cells. The formula assumes the year and month number are in B2 and B3 and that the first date formula is in A5. If you use a different layout, adjust those cell references. Google Sheets usually accepts comma separators; if your spreadsheet locale expects semicolons, replace the commas with semicolons.
Format the date column and add day names. Select A5:A35, then choose Format > Number > Date. To show the weekday in column B, enter this in B5 and fill it down to B35: =IF(A5="","",TEXT(A5,"ddd")). With A5 holding February 1, 2026, the result is “Sun.” If you prefer the full weekday name, change the format text in the formula from ddd to dddd. If you do not want formulas, type dates directly and use Format > Number > Date to keep them consistent.
Enter activities and times. Starting in column C, add start time, end time, activity, category, status, and notes under the matching headings. Enter times as times, such as 9:30 AM, rather than as text with extra words. Use one row per event when a day has several appointments: enter the same date on each relevant row. If you used the date formula above, use it for the initial date list, then type the repeated dates into additional event rows as needed. A simple one-row-per-day plan can instead keep several short tasks in the Activity cell, separated with line breaks.
Make a dropdown for repeatable labels. Select the cells in the Category column where you want choices, such as F5:F100. Choose Data > Data validation, then add a dropdown with options such as Work, Personal, and Appointment. Repeat for the Status column with options such as Planned, Confirmed, and Done. Dropdowns help keep labels consistent, which makes filtering more reliable. Choose options that genuinely match how you will use the schedule rather than adding a long list you will rarely select.
Make the sheet easier to scan. Select the heading row and apply bold text and a background color using the toolbar. Widen columns by dragging the borders between column letters; make Activity and Notes wider than Date or Status. To keep the headings visible as you scroll, click row 4 and choose View > Freeze > Up to row 4. You can also turn on wrapping for long entries by selecting the relevant cells and choosing Format > Wrapping > Wrap.
Add optional color rules. To highlight a status, select the status range and choose Format > Conditional formatting. Set a rule to format cells that contain the text “Done,” then pick a subdued fill color. Add separate rules for “Confirmed” or “Planned” if those colors will help you read the schedule. Apply the rule only to the status cells unless you deliberately want to color entire rows; a row-wide rule needs a custom formula and a correctly selected range.
Turn on filtering and check the result. Select the heading row and the schedule data, then choose Data > Create a filter. Use the filter icons to show only a category, status, or date range. Check that dates appear in chronological order, times are readable, and blank rows do not show unwanted values. If you used formulas, check the last date of the month: a 30-day month should not show a date from the following month. For future months, duplicate the tab and update the year and month inputs before entering new activities.

Common Mistakes

Typing dates in inconsistent formats. Entries such as 3/4/26 can mean different dates depending on locale settings. Use the date picker or a consistent date format, and check the displayed month and day before relying on the schedule.

Putting multiple events in one row without a plan. A table is easiest to sort when each event has its own row. If you put several activities in one cell, you cannot filter them individually or assign separate start times. Use repeated date rows for separate appointments, or reserve a one-row-per-day format for broad daily plans.

Sorting only one column. Sorting the Activity column by itself can separate activities from their dates and times. Select the complete schedule range and use the filter controls so the whole row moves together. Keep the headings in a separate row above the data.

Over-formatting the sheet. Too many colors, merged cells, and decorative borders make a schedule harder to update. Avoid merging cells in the data table: merged cells can interfere with sorting and filtering. Use a small number of colors for meaningful distinctions.

Forgetting to update the month input. If your date formulas refer to B2 and B3, changing the tab name does not change the dates. Update the year and month cells, then review the generated dates and any manually repeated dates.

Tips

Keep a clean template tab and duplicate it for each new month. In Google Sheets, use the arrow beside the sheet tab and choose Duplicate. Rename the copy and update its month inputs before adding events.
Use a short, consistent naming system for categories. “Work,” “Personal,” and “Travel” are easier to filter than several near-duplicates such as “Work task,” “Work meeting,” and “Work admin.” Add detail in the Activity or Notes column instead.
Give the schedule a clear owner if several people edit it. Click Share, add collaborators, and choose an access level that fits their role. Editors can change the schedule, so agree on how people should record changes.
Use notes for details that do not belong in the activity name, such as a meeting link, location, preparation reminder, or contact. Keep sensitive information out of a broadly shared sheet unless everyone with access should see it.
For a visual calendar, add a separate tab with weekday headings and a date grid. A calendar grid is useful for seeing busy and open days at a glance, while the table is better for entering several events on one date. Keeping both views separate avoids making the editable schedule difficult to filter.
This guide uses Google Sheets menu paths in a web browser. Excel has comparable date, filter, and conditional-formatting features, but its ribbon commands and some interface steps are different.

Troubleshooting

The date formula shows an error. Check that the year is a number in B2, the month is a number from 1 to 12 in B3, and the formula is in A5. Confirm that the brackets and commas were copied correctly. If your locale uses semicolons as formula separators, replace the commas. Also make sure the cells used for the inputs are not merged in a way that changes their references.

Dates appear as numbers. Sheets stores dates as serial values, so a date cell can display as a number if it is formatted as a plain number. Select the date cells and choose Format > Number > Date. If the displayed date is still unexpected, check the spreadsheet locale and the values in B2 and B3.

The formula displays as text instead of calculating. Remove any leading apostrophe before the equals sign, make sure the cell is not formatted as plain text, and re-enter the formula. Press Enter after typing it. If a copied formula has smart quotes, replace them with straight quotation marks.

The weekday does not match the date. Check that the weekday formula refers to the date in the same row, such as A5 in B5, and that the date itself is correct. When filling the formula down, use the fill handle so the row references update naturally.

Filtering hides data or mixes up rows. Remove the filter, check that there is one header row and no blank rows splitting the table, then select the full range and choose Data > Create a filter again. Avoid merged cells in the filtered range. If rows were already sorted incorrectly, use Undo immediately or sort the full table by the Date column.

A dropdown or color rule is missing. Check that you selected the intended range when creating the rule. For a dropdown, open Data > Data validation and confirm the rule’s range and choices. For conditional formatting, open Format > Conditional formatting and inspect the apply-to range and condition.

Frequently Asked Questions

Can Google Sheets create a monthly schedule automatically?
Yes. You can generate a list of dates with a formula such as the one above, then enter activities in adjacent columns. Review the dates when you change the month, especially if you have added extra event rows manually.

Should I use a calendar grid or a schedule table?
Use a grid to see the shape of the month and spot busy days. Use a table to manage appointments with separate times, categories, and statuses. For many plans, a calendar tab plus a detailed table gives you both views without compromising either.

How do I make a schedule for a Monday-start week?
The table format does not depend on the week’s first day. If you add a calendar grid, put Monday first in the weekday headings and make sure the grid’s date-generation logic also starts on Monday; do not just rearrange the labels while leaving Sunday-based dates in place.

Can several people edit the same monthly schedule?
Yes. Use Share to invite people or create a shareable link with the appropriate permissions. Give edit access only to people who should make changes, and agree on a consistent way to enter dates, categories, and updates.

How do I reuse the schedule next month?
Duplicate the tab, rename the copy, and update the year and month inputs used by the date formulas. Review dates you entered manually, repeated dates for extra events, and any old activities before sharing or using the new tab.

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.