Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > NOW
 

NOW()

 
 Returns the serial number of the current system date and time.

 REMARKS
 
  		• This function is volatile and will change everytime a cell on the worksheet is calculated.
     
  		• This function will update when the workbook is recalculated by pressing F9.
     
  		• This is one of few functions that does not require any arguments.
     
  		• You must include the empty parentheses after the function name.
     
  		• The serial number is the date-time code used by Excel for date and time calculations.
     
  		• If the cell contains the General number format, then the format is automatically changed to "dd/mm/yyyy hh:mm".

     EXAMPLES
     
     A
    1=NOW() = 7/31/2007 20:17
    2=NOW()-1 = 7/30/2007 20:17
    3=DAY(NOW()) = 31
    4=MONTH(NOW()) = 7
    5=YEAR(NOW()) = 2007
    6=HOUR(NOW()) = 20
    7=MINUTE(NOW()) = 17
    8=SECOND(NOW()) = 34
    		 
     Functions - N | Index - N | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top