See all How-To Articles

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 4

 

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.

 

display current date in header 1

 

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.

 

display current date in header 2

 

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.

 

display current date in header 3

 

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).

 

display current date in header 4

 

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).

 

google sheets display current date in header

 

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).

 

google sheets display current date in header 2

 

By default, the current date is added in the left bottom footer section as you can see below.

 

google sheets display current date in header 3

 

3. To add the current date to the header (for example, the top central), go to Edit custom fields.

 

google sheets display current date in header 4

 

4. Click on the section where you want to insert the current date (top central).

 

google sheets display current date in header 5

 

5. Click on the calendar icon, and choose a date format (for example Date 1).

 

google sheets display current date in header 6

 

6. Now the [Date1] is in the header section, click outside the header, and Confirm.

 

google sheets display current date in header 7

 

As a result, in the print preview, you can see the current date (10/25/2021) in the middle of the header.

 

google sheets display current date in header 8