Friday, December 31, 2010

EXCEL: Current Time/Date

Like Word, you can also enter the current time/date in a worksheet by entering the following calculation:

=NOW()

You then go in and format that cell how you want the date to look:

  • Format
  • Cells
  • Date
Then, every time you open that worksheet, the current time/date will appear!  Watch how you use this, though, there are only very specific reasons why you would want to set your worksheet up this way.  Be sure this is how you really want it to show today's date.

No comments:

Post a Comment