Add Element to Header to Display Current Date in Excel & Google Sheets
This tutorial demonstrates how to add the current date to the header in Excel and Google Sheets.
Display Current Date in Header
In the header of your Excel document, you can insert a date element; it will always display the current date.
1. In the Ribbon, go to Insert > Header & Footer.
2. Now you can see three header sections. Double-click on the header section where you want to insert the current date (here, the center section). You’re automatically taken to the Header & Footer tab in the Ribbon. Here, choose the Current Date.
As a result of the previous step, in the center section of the header, you can see &[Date]. This stands for the current date as a header field.
From the Header & Footer tab, you can also insert the page number, number of pages, current time, file path, file name, sheet name, or picture.
3. If you click on the worksheet somewhere outside the header sections, you can see the current date (10/25/2021).
See also: How to Insert or Remove the Header and Footer.
Display Current Date in Header in Google Sheets
You can also insert the current date in the header in Google Sheets.
1. In the Menu, go to File > Print (or use the keyboard shortcut CTRL + P).
2. In the window on the right side, you check Current date (in Google Sheets, you can also insert in the header page numbers, the workbook title and sheet name, or current time).
By default, the current date is added in the left bottom footer section as you can see below.
3. To add the current date to the header (for example, the top central), go to Edit custom fields.
4. Click on the section where you want to insert the current date (top central).
5. Click on the calendar icon, and choose a date format (for example Date 1).
6. Now the [Date1] is in the header section, click outside the header, and Confirm.
As a result, in the print preview, you can see the current date (10/25/2021) in the middle of the header.
