Insert current DATE in Excel

Image of calendar
Purpose

Display today’s date in a cell

Syntax

=TODAY()

Method
  1. Select the cell where the date needs to be displayed
  2. Type: =TODAY()
  3. Press Enter
Description

Today’s date will be displayed in the cell and update every time the file is opened.

Related

The NOW() function which displays the date AND time.