Hints and tips home » Excel hints and tips » Adding date and time

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

Added by Alan on 16th September 2006

More Excel hints and tips, like:

• Adding up rows or columns without seeing formulas
• Fill formulae across a sheet
• Convert Text into Number