Microsoft excel formula?

how do you get automatic dates and time into microsoft excel

its for coursework, and i have forgotten how to do it.

Microsoft excel formula?free spyware remobal

Date:

=TODAY()

TIME:

=NOW()

You'll need to format the cell to how you want it displayed

Microsoft excel formula?kawasaki

As another answerer said:

NOW and TODAY functions.

If you just want to put in the current time or date, that do not change

Ctrl and :

or

Ctrl and ;

are nice quick shortcuts.
look up tools edit and formula
use =TODAY() to insert current date automatically, and use =NOW() to insert current time. Please note, the TODAY() and NOW() functions change only when the worksheet is re-calculated or when the function is contained in run macro. Value are reflection of your computer date and time and these values are NOT continuously updated.
=now() or =today() or if you don't need it to update, Ctrl; or Ctrl: