Shortcut to adding date and time in Excel

Yes, you could write a formula or you could manually put in today's date (10/28/11), but there is an easier way!!!

In the cell you want the date to appear, press Ctrl-; (semicolon) and watch it input the current date! 

If you really want the exact time (3:49 PM), then you need to press Ctrl-Shift-; (semicolon).

The important thing to remember is that these do not update, so if you open the workbook tomorrow, it will still be 10/28/11.

Try it out! It just might save you time!