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 Reply

MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number)

Read More »


The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »

RAND Function

The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel,

Read More »
Scroll to Top