Add Element to Header to Display Current Date in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on August 21, 2023

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 an Excel document, you can insert a date element that always displays the current date.

  1. In the Ribbon, go to Insert > Header & Footer.

display current date in header 1

  1. Now you 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, 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.

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

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

  1. In the window on the right, tick 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

  1. To add the current date to the header, go to Edit custom fields.

google sheets display current date in header 4

  1. Click on the section where you want to insert the current date (top center).

google sheets display current date in header 5

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

google sheets display current date in header 6

  1. 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 Print Preview mode, you can see the current date (10/25/2021) in the middle of the header.

google sheets display current date in header 8

AI Formula Generator

Try for Free

See all How-To Articles