YEAR function in Excel

Use

YEAR function is used to extract 4-digit year number from a given Excel’s format date. For example, from a date of 30-Dec-1991, you can extract the year of 1991 only in another cell.

Syntax

=YEAR(date)

Where (date) is Excel’s format date from which you will extract year only.

Example

Formula:

Results:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved