1000 Excel Formulas
Home
Categories
About
Search
YEAR
Date
Converts a serial number to a year
Syntax:
=YEAR(serial_number)
Example:
=YEAR("1/1/2023")