Excel: Display Current Date and Time in Spreadsheet

Excel: Display Current Date and Time in Spreadsheet

You may find it appropriate to insert the current date and/or time in an Excel file and have it continually update so that these items always display when you open the file.

In Excel 2007, 2010, 2013, and 2016:

  1. Click the "Insert" tab > Click [Header & Footer] in the "Text" group.
  2. Under the "Design" contextual tab, click [Current Date] or [Current Time] in the "Header & Footer Elements" group.
  3. Click outside the header or footer to display.

In Excel 2003:

  1. Select the cell where you wish to place the date.
  2. Go to "Insert" > "Function."
  3. Choose "Date & Time" from the "Select a category" dropdown list.
  4. Under "Select a function," scroll and select "TODAY."
  5. Click [OK]. A "Function Arguments" dialog box will open; however, no arguments are needed for this function.
  6. Click [OK].
  7. Today's date will display.

Keywords: Office 2010, Office 2013, Microsoft Office Suite, excell

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty