Create and Print a One-Day-Per-Page Diary in Excel
Question details
Create a full-year diary in Excel where each calendar day is displayed and printed on its own page.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to build a reusable daily diary layout with automatically generated dates and weekday names.
- Observed behavior
- The desired result is a portrait worksheet with one day per printed page and dates that progress automatically through the year.
Decide which cell range will represent one diary page, including room for notes or appointments. Enter the first diary date manually so the following dates can be generated consistently with formulas.
Build a full-year Excel diary with one printed day per page
Use this method to create a 365-day diary with sequential dates, weekday labels, and manual page breaks between daily layouts.
Set up one daily layout first, then use a date formula to generate each following day. Define the printable range and use page breaks so every daily section is printed as a separate page.
In Excel, open the Page Layout tab, select Orientation > Portrait, and set margins as needed. Create the diary layout for one day, such as a date heading at the top and writing space below it.
Type the first date of the year in cell A1, such as 1/1/2025. In a weekday cell, enter =TEXT(A1,"dddd") to show the full weekday name.
In the first date cell for the next daily section, enter =A1+1, replacing A1 with the cell that contains the preceding date. Copy the date formula and the =TEXT(date_cell,"dddd") weekday formula through all required daily sections.
Select the complete diary range, then choose Page Layout > Print Area > Set Print Area. Open View > Page Break Preview and drag the blue page-break lines, or use Page Layout > Breaks > Insert Page Break, so each day occupies one page.
Select File > Print to preview every page. Confirm that each page contains one day, then adjust scaling, margins, or page breaks before printing.

Add the date to each diary page header
Use a header when you want the printed date to appear consistently at the top of each page without taking up space in the diary body.
Make a One-Day-Per-Page Diary with WPS Spreadsheets
WPS Spreadsheets lets you create a daily diary layout, generate consecutive dates with formulas, add weekday names, insert page breaks, and preview the full-year diary before printing. Its familiar spreadsheet interface makes it easy to work with Excel diary files.
- 1. Create the daily diary layout: Open WPS Spreadsheets, create a blank workbook, and choose Page Layout > Orientation > Portrait. Design the cells that will make up one daily diary page.
- 2. Add automatic dates and weekdays: Enter the first date in a starting cell. In the next daily date cell, enter =previous_date_cell+1, and use =TEXT(date_cell,"dddd") in another cell to display the weekday.
- 3. Define the printable diary range: Select the diary content, then choose Page Layout > Print Area > Set Print Area to limit printing to the intended daily pages.
- 4. Separate each day into its own page: Open View > Page Break Preview and drag page-break boundaries, or choose Page Layout > Breaks > Insert Page Break between daily sections.
- 5. Preview and print: Choose File > Print to inspect the page sequence, then adjust margins or scaling and print the completed diary.

Frequently Asked Questions
How do I make Excel increase the date by one day for every diary page?
Enter the first date manually, then enter =A1+1 in the next date cell, replacing A1 with the preceding date cell. Copy the formula to each subsequent daily section.
How can I display the weekday beside a date in Excel?
Use =TEXT(A1,"dddd"), replacing A1 with the cell containing the date. The formula returns a full weekday name such as Monday or Tuesday.
How do I print one diary day on each page in Excel?
Set the diary range through Page Layout > Print Area > Set Print Area. Then use View > Page Break Preview or Page Layout > Breaks > Insert Page Break to place a page break after every daily section.
Can I use one Excel diary layout again next year?
Yes. After creating the layout, choose File > Save As and save it as an Excel Template (*.xltx). For a new year, open the template and change the first date cell.
Why does my Excel diary print multiple days on one page?
Check File > Print for scaling settings such as Fit Sheet on One Page, which can combine content. Use Page Break Preview to set a page break after each day and confirm the print area includes the correct range.




