Name
YEAR
Synopsis
Use this function to return the year portion of a date. For example, if the date is 4/22/92, this function will return a value of 1992.
To Calculate
=YEAR(Serial_Number
)
Example
This function is typically used to determine the year value of a date in another cell. The value in the cell can either be a typical date value, such as 5/16/1998, or a serial number. The HOUR function covered in this chaper has an example illustrating how YEAR can get the year value from a serial number.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.