This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Microsoft Excel 2003/2004

Inserting Dates and Times

Excel offers a variety of ways to include dates and times into your worksheets. Static and dynamic are two types of dates and times. Static dates and times will not change but dynamic dates and times will change as time progresses. Nevertheless, both static and dynamic dates and times are useful.

return to topInserting Dynamic Dates and Times

Dynamic dates and times are updated every time Excel recalculates, which is, by default, every time [Enter] or [return] is pressed. This is useful if you would like the current date and/or time to be displayed every time the worksheet is viewed or printed.

Inserting a Dynamic Date Only

  1. Select the cell in which you want the date to appear

  2. In the cell, type =today()

  3. Windows: Press [Enter]
    Macintosh: [return]
    The current date appears in the cell and will be updated every time Excel recalculates.
    NOTE: For information on changing the format of the date, refer to Formatting Your Worksheets.

Inserting a Dynamic Date and Time

  1. Select the cell in which you want the date and time to appear

  2. In the cell, type =now()

  3. Windows: Press [Enter]
    Macintosh: [return]
    The current date and time appear in the cell and will be updated every time Excel recalculates.
    NOTE: For information on changing the format of the date and time, refer to Formatting Your Worksheets.

return to topInserting Static Dates and Times

Static dates and times are not updated. The date or time that is inserted into the cell is the date or time immediately after the command is entered into the cell. This can be used to enter the date or time when the worksheet has been created.

Inserting a Static Date

  1. Select the cell in which you want the date to appear

  2. Windows: Press [Ctrl] + [;]
    Macintosh: Press [control] + [;]
    The current date appears in the cell and will not be updated.
    NOTE: For information on changing the format of the date, refer to Formatting Your Worksheets.

Inserting a Static Time

  1. Select the cell in which you want the time to appear

  2. Windows: Press [Ctrl] + [Shift] + [:]
    Macintosh: Press [Ctrl] + [Shift] + [:]
    The current time appears in the cell and will not be updated.
    NOTE: For information on changing the format of the time, refer to Formatting Your Worksheets.

Excellence. Our Measure. Our Motto. Our Goal.