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

YEAR(serial_number)

 
 Returns the year as an integer given a date serial number.

 serial_numberThe date that contains the year you want to find.

 REMARKS
 
  		• The "serial_number" can be a date value, a serial number or a reference to a cell containing a date.
     
  		• If "serial_number" < 0, then #NUM! is returned.
     
  		• If "serial_number" is not a valid date, then #VALUE! is returned.
     
  		• You can obtain the serial number from a date by using the DATE() function.
     
  		• You can use the DATEVALUE() function to return the serial number representing a date in a text format.

     EXAMPLES
     
     AB
    1=YEAR(B1) = 200301 July 2003
    2=YEAR("01 July 2003") = 2003=NOW() = 31/07/2007
    3=YEAR(B2) = 2007=NOW() = 39295
    4=YEAR(38093) = 2004 
    5=YEAR(DATE(1977,7,1)) = 1977 
    6=YEAR(0) = 1900 
    7=YEAR(-10) = #NUM! 
    8=YEAR("some text") = #VALUE! 
    		 
     Functions - Y | Index - Y | Dates & Times | Office Online 

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