Insert and format the current date and time

Do any of the following:

Insert a static date or time

  1. Select the cell.

  2. Do one of the following:

To insert the

Select a cell and press

Current date


Current time


Insert a date or time whose value is updated

  1. Select the cell.

  2. Do one of the following:

To insert the


Current date


Current date and time

=NOW ()

Bemærk: The TODAY and NOW functions change only when the sheet is recalculated. Functions are not updated continuously. The date and time values are updated from the computer's system clock.

Change the date or time format

  1. Select the cell.

  2. On the Home tab, under Number, click the Number Format box   Feltet Formatér tal  , and then click Custom.

  3. Under Category, select Date or Time, and then select a format in the Type list.

    Bemærk: Excel cannot display both a time and a date format in the same cell. When you select one format, the other information will no longer be displayed in the cell.

See also

Enter a series of numbers, dates, or other items

Subtract dates

Subtract times

Show dates as days of the week

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!