Skip to content
Guide for Beginners
Menu
  • Home
  • Email & Messaging
    • Gmail
  • Facebook
  • G-Products
  • Hotmail
  • Mobile Guides
    • Android
    • iOS
  • Office
    • Excel
  • Wikituts
Menu

How to Use Excel YEAR Function

Posted on December 9, 2021November 4, 2022 by Pink Mit

The Excel YEAR function extracts the year from a given date as number between 1900 to 9999. You can use the YEAR function to extract a year number from a date into a cell, or to feed a year number into another function like the MONTH function.

1. Learn about the Excel YEAR function

Syntax:

=YEAR(serial_number)

Where serial_number is any valid Excel date of the month.

The Excel YEAR function extracts the year from a given date as number between 1900 to 9999. For example, given the date “Jul 08, 2020”, the YEAR function will return 7 for July.

Dates can be supplied to the YEAR function as text (e.g. “10-Nov-2021”) or as native Excel dates, which are large serial numbers.

2. Examples of Excel YEAR function

=YEAR(“16-Jul-2019”) // returns 2019

=YEAR(“06-Aug-2020”) // returns 2020

With the date “November 23, 2021” in cell A2, YEAR returns 2021:

=YEAR(A1) // returns 2021

Note: dates are serial numbers in Excel, and begin on January 1, 1900. Dates before 1900 are not supported.

3. Common errors when using the YEAR function in Excel

YEAR will return #VALUE! if a date is not recognized. Please enter exactly what the function requires is day, month, year in numbers.

YEAR will return #NAME? if you entered the error value is a letter or a character. For example: YEAR(AA), YEAR(A@)

YEAR will return #NUM! if a date is supplied as a number that is out of range (i.e. 1800).

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Android (1)
  • Email & Messaging (11)
  • Excel (3)
  • Facebook (10)
  • G-Products (13)
  • Gmail (15)
  • Hotmail (3)
  • iOS (4)
  • Mobile Guides (3)
  • Office (3)
  • Wikituts (291)

Recent Comments

No comments to show.

About

Smalltuts.com – Guide for Beginners – The main goal of this website is to provide quality tips, tricks, and other resources that can be used expertly by beginners.

Mail: info@smalltuts.com

Pages

  • Contact
  • Disclosure
  • Privacy Policy
  • Terms & Conditions
©2023 Guide for Beginners | Design: Newspaperly WordPress Theme