Create an Excel Weekly Calendar Organized by Month
Question details
Create an Excel calendar with one complete week per row, organized by month.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants a weekly calendar layout rather than a calendar that emphasizes individual days.
- Observed behavior
- The desired calendar groups whole weeks by month, with each week displayed in a single row.
Choose the year and whether weeks should start on Monday or another day. Decide whether to place each month on a separate worksheet and how to handle weeks that cross month boundaries.
Find and Adapt an Excel Weekly Calendar Template
Use this approach if you prefer to start with an existing calendar layout.
In Excel, select File > New and search for weekly calendar, academic calendar, or Julian calendar.
Open a template preview and look for a layout that places a complete week in each row. Select Create if the template is suitable.
Use the worksheet tabs to place each month on a separate sheet if needed. Adjust the dates and headings to match your chosen year.

Build a Weekly Calendar on Monthly Worksheets
Create a custom layout when the available templates do not show whole weeks in rows.
Build a Monthly Weekly Calendar in WPS Spreadsheet
Use WPS Spreadsheet to create a calendar with one week per row and a separate worksheet for each month, then save it as an Excel-compatible workbook.
- 1. Start a workbook: Open WPS Spreadsheet and create a blank workbook. Enter Week starting in A1 and Monday through Sunday in B1:H1.
- 2. Set the first week: Enter the Monday on or before the first day of the month in A2. Enter =A2 in B2 and =B2+1 in C2, then drag C2 across through H2.
- 3. Fill the month: Enter =A2+7 in A3, copy B2:H2 into B3:H3, and fill A3:H3 down until the month is covered. Format the date cells using the Home tab.
- 4. Add months and save: Use the worksheet tabs to create or copy a sheet for each month, update A2 on each sheet, and use File > Save As to save the workbook as an XLSX file.

Frequently Asked Questions
Where can I find weekly calendar templates in Excel?
Go to File > New and search for weekly calendar, academic calendar, or Julian calendar. Preview the results to check whether each week appears in one row.
How do I put each month on a separate worksheet?
Use the worksheet tabs at the bottom of the workbook to add or copy sheets. Rename each tab for its month and update the dates on each sheet.
What should I do when a week spans two months?
You can show the complete week on both monthly sheets or keep it on only one sheet. Choose one approach and apply it consistently.
Can I edit an Excel calendar in WPS Spreadsheet?
Yes. Open the XLSX workbook in WPS Spreadsheet, edit the calendar cells and worksheet tabs, and save it as an XLSX file.




