Excel YEAR() function

Last update on August 19 2022 21:50:55 (UTC/GMT +8 hours)

YEAR() function

This function is used to return the year corresponding to a date. The year is returned as an integer in the range 1900-9999.

Version: Excel 2013

Syntax:

YEAR(serial_number)

Parameters:

Name	Description	Data Type	Required/ Optional
Serial_number	The date of the year you want to find. It is better to use date by using the DATE function like DATE(2008,5,23) for the 23rd day of May, 2008.	Date	Required

Remarks:

Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2010, is serial number 40179 because it is 40178 days after January 1, 1900.

The values returned by the YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value.

Example - 1:

The example below returns the year of the date specified in cell A4.

year1

Example - 2:

The example below returns the year of the date specified in cell A4.

Previous: Excel WORKDAY.INTL() function
Next: YEARFRAC() function