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, 2021

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.

Maybe you are interested
  • How to Use Excel YEAR Function
  • How to Use Excel MONTH Function

1. Learn about the Excel YEAR function

Syntax:

You are reading the article: How to Use Excel YEAR Function

=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.

See also : How to Use Excel MONTH Function

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

See also : How to Use Excel HLOOKUP Function

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).

Source: https://smalltuts.com
Category: Excel

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 - All rights reserved.