Function Type: Date and Time
Description:
Converts a serial number to a year.
Function Structure:
=YEAR(serial_number).
Argument Breakdown:
serial_number – The date of the year you want to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.