Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

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-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link