w3resource

Excel YEAR() function

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.

year2

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



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/excel/excel-year-function.php