Want to learn more about how to returns an integer representing the year of a supplied date using excel spreadsheet?? This post will give you an overview of how to returns an integer representing the year of a supplied date in excel.

**Syntax(Generic Formula)**

`=YEAR(serial_number)`

**Serial_number****[Required]**: It is the date of the year that we want to find. By using DATE function, date enter.

**How the YEAR function Works**

The YEAR function in Excel is a date & time function that is used for returns the year number from a given date. The function will return a four-digit year integer that is a year corresponding to a mentioned date.

*Figure 1: **Example of **returns the year corresponding to a date*

To find the year corresponding to a date the YEAR you can use the function. In the example selected cell shown, the formula in D6 is:

`=YEAR(C6)`

The Excel YEAR function returns the year component of a date as a 4-digit number. In Excel YEAR function you can extract a year number from a date into a cell.

**More about Excel YEAR Function**

- Excel can store in a serial number form.
- if the reference date is valid then It will only return year number
- You can extract only year number from given date which must be after 01-01-1900.
- It will return year in four digits.

## Leave a Comment