Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

YEAR

Description: Returns the year from the specified date value. The date can be entered as text in a valid date format or as a serial number. For example, the function returns 2011 if you enter "12/11/2011" or "40888."

Syntax: YEAR(Serial_number)

Remarks:

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.