How to use Excel YEAR function

Introduction

YEAR function in Excel is a type of DATE/TIME function. It used to find YEAR of a specified date. It can be used to supply YEAR into a cell or used with functions like DATE function as a feeder.

Syntax

=YEAR( Date )

Arguments

  • Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form of text are entered then there is a possibility of getting an error.  

Keynotes

  • In General formatting of Excel, Dates are in form of serial numbers. Serial number 1 is for 1 JAN, 1900 and the number increases from thereon. For getting it in readable form use the formatting function.
  • A valid Excel date must be used.
  • For text values #VALUE error is displayed.

Examples

12/2/2018
5/8/2018
2018 September 9th

In this example we used the following dates:

At B7, an invalid format is used so we used DATE and YEAR function together.

Leave a Reply

Close Menu
×

Cart