Thursday, March 31, 2011

Insert Current Date and Time In A Cell

There is a simple way of inserting Date and Time in to a cell in an Excel Worksheet. Microsoft Excel provides an easier way of entering a date and time that is static and which gets updated along with computer clock, just by pressing keys and also by using functions.The value of date and time can vary as well according to the computer clock.

Steps to Insert static Date and Time:

 A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as CTRL+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell. That cell’s value doesn’t change, so it’s considered static.
  1. On a worksheet, select the cell into which you want to insert the current date or time.
  2. Do one of the following:
    • To insert the current date, press CTRL+; (semi-colon).
    • To insert the current time, press CTRL+SHIFT+; (semi-colon).
    • To insert the current date and time, press CTRL+; (semi-colon), then press SPACE, and then press CTRL+SHIFT+; (semi-colon).
 Functions that will update Date and Time whenever we reopen the workbook: 
  •  =Now() : This function will insert Current Time into the cell where cursor is present. 

  •  =Today() : This function will insert today's date into the cell where cursor is present. 

The results of the TODAY and NOW functions change only when the worksheet is calculated or when a macro that contains the function is run. Cells that contain these functions are not updated continuously. The date and time that are used are taken from the computer's system clock.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More