YEAR Function or YEAR Formula in Excel with example

YEAR Function or YEAR Formula in Excel with example

YEAR

Returns numeric YEAR value. Year function is very useful in Excel when you wish to extract only Year from a date. Year function takes one parameter serial_number, and returns the year of given date, an integer in the range of 1900 to 9999.

Syntax

=YEAR(serial_number)

  • serial_number: refers to a valid date from which year needs to be extracted.

Formula

Output

Next >> MONTH Function in Excel with example

Leave a Reply

Your email address will not be published.