Excel: Display Current Date and Time in Spreadsheet

Excel: Display Current Date and Time in Spreadsheet

You may find it helpful 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.

Excel 2016, 2013, 2010, and 2007

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

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