YEAR Function in Excel

In this tutorial, you will learn YEAR formula in excel. YEAR function in excel can help separate twelvemonth period number from a date data which you give as its input.

Why We Need to Learn About YEAR Formula in Excel?

In processing date data in the spreadsheet tool, sometimes we only need the twelvemonth period part of the data so we want to separate it. The problem is probably there are various kinds of writing for this kind of data in your spreadsheet so it will be a little bit harder to do the separation manually because we need to scan all of those forms. Besides, there are probablu many dates to be processed that it will take time to separate them one by one.

As a case example in the real world, imagine if we want to create a special column in our company product data for the production year of each product. This can be done by pulling it from the data in production date column. However, if there are more than thousands of products and there are also some date writing forms where each form is different from the other, then it will be very difficult and wasting a lot of time to do the separation manually.

Another example is probably when we want to do additional or subtraction process to numbers in a financial report and we need the twelvemonth periods data from the dates of in and out process of cash flow recordings first first before doing the calculation process. With entries of cash flow recordings that usually are many, it will take a long time if we still need to do the manual separation process first on the recording dates before we can do addition or subtraction to the numbers related to the recordings’ time in the cash flow transactions.

If we want to do it automatically, then we can use YEAR formula in excel which can help to do the separation fast. YEAR function in excel is very useful if we often need to process data related to dates in work or business every day.

What is YEAR Function in Excel?

YEAR function in excel is a function with the usage objective to separate twelvemonth period data from a date. The result of YEAR formula in excel can be directly used for the calculation process that you want to do with its data result.

This is a bit explanation about the input in this formula:


serial_number = the date that you want to take the year number from

How to Use YEAR Formula in Excel?

The following will explain how to write YEAR function in excel. YEAR formula in excel only needs the date data input on where it will do the separation process.

Using YEAR Function in Excel

  1. Type equal sign ( = ) in the cell where you want to put the result in

    YEAR Function in Excel - Screenshot of Step 1

  2. Type YEAR (can be with large and small letters) and open bracket sign after =

    YEAR Function in Excel - Screenshot of Step 2

  3. Type date or cell coordinate where the date which you want to process is, after open bracket sign

    YEAR Function in Excel - Screenshot of Step 3

  4. Type close bracket sign

    YEAR Function in Excel - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    YEAR Function in Excel - Screenshot of Step 6


After you have learned how to use the YEAR formula in excel above, you can practice your understanding by doing the exercise below!

Download the file from the following link and answer the questions below. Please download the answer if you have done answering the questions and sure about the result!

Link to download exercise file:
Download here


  1. Fill no. 1 column with the twelvemonth period of each column B’s cell content!
  2. How much is the difference between the current twelvemonth period and each of the data in column C? (Instruction: use TODAY formula to get today’s date that should be processed before it is subtracted with the numbers in column C!)
  3. All the materials are not in good condition to use after 100 days after production. What is the twelvemonth period expiration of each material? (Instruction: add 100 on each cell content in column B before it is processed!)

Link to download answer file:
Download here

Additional Note

If you want to get month or day number from a date data of yours, then you can use MONTH (for the month) and DAY (for the day) formulas.

Want to Learn More About Excel?

Get updated excel info from Compute Expert by registering your email. It's free!

Want to Learn More About Excel?

Get updated excel info from Compute Expert by registering your email. It's free!

Follow our tutorial content also on

Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation

Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel

Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel

Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition

© 2021 Compute Expert