YEAR

Returns the Year component of a given date in Excel
Converts a serial number to a year

Rational

Returns the Year component of a given date.

Description

The Excel YEAR function extracts an integer after 1900 that corresponds to the Year component of a given date. Example; to get or find Year from a date (11/08/2017- cell B5), use =YEAR(B5), that returns ‘2017’.
Isolating the year part of a date is useful if application where only year component is required in a specific argument.

Syntax

=YEAR(serial_number)

Parameters

Serial_number – A valid argument of date, string representation or a serial number of a specific date.

Return Value

An Integer representing year component of a date.

Key Notes

  • A valid date format in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
  • Use YEARFRAC function returns a proportion of a year representing the number of whole days.
  • As with all dates in Excel, what you end up with is a serial number, but the Date formatting displays the date in a readable fashion.
  • Excel accepts two different Date System, return #VALUE! error in case you enter a date before January 01, 1900 for Windows and January 1, 1904 for Macintosh.

Keep Reading Similar Functions:

Determine the difference between two dates in Excel

DATEDIF

The DATEDIF is an unknown compatibility function that can be used to calculate the difference between two dates. To find years diff.,=DATEDIF(start_date, end_date,”y”).

Read More »
Find the difference between two dates in Excel

DAYS

The DAYS function returns the difference between two dates. To find days duration between two dates, use DAYS(“01/08/2018″,”01/05/2017”) that returns ‘457’.

Read More »
Returns a proportion of years for a given range of dates in Excel

YEARFRAC

The YEARFRAC function finds the fraction of years between two dates, like 01-01-2017 and 30-09-2017, use =YEARFRAC(startdate,enddate,2), that returns ‘0.755’.

Read More »