YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or use the year in a formula.




  • serial_number – A valid excel date that is referenced to extract the year.

Year Function Usage Example

In Excel, dates are actually serial numbers. Read more on How are Dates stored in Excel.

By using the formula, you can easily extract the year of any given date. The example below shows how Excel extracts this date regardless of the formatting.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend