Insert today's date in an Excel cell

You can quickly add today's date or time into an Excel spreadsheet by pressing:

Date: Ctrl+Semicolon
Time: Ctrl+Shift+Semicolon

To get Excel to update the sheet everytime you open it with today's date, just put the following into the formual bar of the cell...

=TODAY()

Note: If you try to record a macro using the Ctrl+Semicolon or Ctrl+Shift+Semicolon, you will get a hard coded date recorded in your macro...