Year Formula in Microsoft excel

 

 

YEAR

Check below example and try to use in excel in real time for better understanding

Blue text start with "=" is the formula we used

 

What Does It Do ?

This function extracts the year number from a date.

Syntax

=YEAR(Date)

Formatting

The result is shown as a number.

">