Site icon ExcelNotes

How to Use YEAR Function

The YEAR function returns the year of a date.

Formula:

=YEAR(serial_number)

Explanations:

Serial_number is required, the date you need to find the year.

Cautions:

Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.

Download: YEAR Function

Exit mobile version