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

 

TODAY()

 
 Returns the current system date as a serial number.

 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 the 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 Microsoft Excel for date and time calculations.
     
  • If the cell contains the General number format, then the format is automatically changed to "dd/mm/yyyy".

     EXAMPLES
     
     A
    1=TODAY() = 31/07/2007
    2=TODAY()-1 = 30/07/2007
    3=DAY(TODAY()) = 31
    4=MONTH(TODAY()) = 7
    5=YEAR(TODAY()) = 2007
     

     Functions - T | Index - T | Dates & Times | Office Online 

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