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.

Syntax:

 =YEAR(serial_number) 

Arguments:

  • 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

VBA Comment Structure

This section of the VBA learning course reviews the Comment Structure. In every programming language, you need to have the

Read More »

MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number)

Read More »
Scroll to Top