Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

I need to print out a diary for work with the date at the top of each page for a whole year

Copper Contributor

I need to make my own diary set up with a day to a page and the date and day at the top of the page. 365 days to make a year diary.  Does anyone know how I can get the date to update at the start of every page.

1 Reply


To create a diary with a day to a page and have the date update automatically at the top of each page, you can use Excel and set up a template. Here's a step-by-step guide:

  1. Create a New Worksheet:
    • Open a new Excel worksheet.
  2. Set Up the Page Layout:
    • Go to the "Page Layout" tab.
    • Set the orientation to "Portrait" if it's not already.
  3. Set Print Area:
    • Highlight the entire worksheet (Ctrl + A).
    • Go to the "Page Layout" tab and click on "Print Area" -> "Set Print Area."
  4. Create the Date and Day Headers:
    • In the first cell (A1), enter the formula to display the current date:


    • In the adjacent cell (B1), enter the formula to display the day corresponding to the date:

=TEXT(A1, "dddd")  

5. Format the Date and Day Cells:

    • Format the cells (A1 and B1) to make them visually appealing. You can choose a suitable font, size, and color.

6. Set Up Page Header:

    • Go to the "Insert" tab and click on "Header & Footer."
    • In the header section, click where you want the date to appear.
    • Click on "Insert Date" and select the appropriate date format.

7. Copy the Date and Day Formulas:

    • Copy cells A1 and B1.
    • Paste them into the entire column A (from A2 to A1048576 or the last row you want).

8. Adjust Page Breaks:

    • Go to the "View" tab and select "Page Break Preview."
    • Adjust page breaks if necessary to ensure each day is on a separate page.

9. Save as a Template:

    • Save this worksheet as a template if you plan to reuse it. Go to "File" -> "Save As" and choose "Excel Template (*.xltx)" as the file type.

10. Print:

    • Go to "File" -> "Print" to check how your pages will look when printed. Adjust settings as needed.

This setup will automatically update the date at the top of each page when you open the file or print it. Each page will represent one day of the year. The text and steps were edited with the help of AI.

Remember to save your template, so you can reuse it for subsequent years if needed.


Additional: Diary Templates from Microsoft

  • Keep track of everything in style with customizable calendar design templates.



My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.