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

insert date in excel header that is not the current date

Copper Contributor

insert date in excel header that is not the current date

1 Reply


In Excel, you can insert a specific date into the header of your worksheet, even if it's not the current date. Here are the steps to insert a custom date into the header:

  1. Go to the Header/Footer Section:
    • Double-click on the header section or go to the "Insert" tab on the ribbon and click on "Header & Footer."
  2. Insert a Custom Date:
    • While in the header section, you can insert a custom date using the following steps:
      • To insert the current date: Click on the "Date" button in the "Header & Footer Elements" group on the ribbon.
      • To insert a custom date: Type the desired date directly into the header. For example, you can type January 1, 2023.
  3. Format the Date (Optional):
    • If you want to format the date differently, select the date in the header, right-click, and choose "Format Cells." Adjust the formatting options according to your preference.
  4. Exit the Header/Footer Section:
    • Once you have inserted the date and made any necessary formatting changes, you can exit the header/footer section by double-clicking outside the header/footer area or clicking on the "Go to Footer" or "Go to Header" buttons on the ribbon.

Remember that the date you insert in the header is static and won't automatically update like the built-in date function, which inserts the current date. If you need a dynamic date that updates automatically, you can use a formula to display the current date in a cell and link the header to that cell. For example:

  1. Type =TODAY() in a cell to display the current date.
  2. In the header, type &A1 (assuming the date is in cell A1).

This way, the header will always display the current date based on the formula in cell A1.

The text was created with the help of AI.

If none of these steps help you, I recommend adding more information to your topic. Information such as Excel version, operating system, storage medium, file extension, etc.

In this link you will find some more information about it:

Welcome to your Excel discussion space!


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.