Printing Problems

Create and Print a One-Day-Per-Page Diary in Excel

Kushani NimanthikaKushani Nimanthika Nov 12, 2026 869 views

Question details

Create a full-year diary in Excel where each calendar day is displayed and printed on its own page.

Create and Print a One-Day-Per-Page Diary in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Set the daily page layout

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.

2
Enter the first date and weekday formula

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.

3
Generate the next dates

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.

4
Set the print area and page breaks

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.

5
Review and print the diary

Select File > Print to preview every page. Confirm that each page contains one day, then adjust scaling, margins, or page breaks before printing.

Build a full-year Excel diary with one printed day per page
Reusable annual diary layout: When the layout is complete, select File > Save As and choose Excel Template (*.xltx) to reuse the same one-day-per-page design for another year.
Create and print daily diary pages

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. 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. 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. 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. 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. 5. Preview and print: Choose File > Print to inspect the page sequence, then adjust margins or scaling and print the completed diary.
Generate daily dates with formulas such as =A1+1 and weekday labels with TEXT.Use Print Area and Page Break Preview to print one diary day per page.Add headers, adjust portrait layout, and review pages before printing.Open, edit, and save Microsoft Excel XLSX and XLS files with strong format compatibility.
microsoft office alternative - wps office

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.