Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Get year from date

Read time: 15 minutes

Figure 1. Get Year From Date in Excel.

If we have a date list which we want to extract the year from, we are going to make use of the Excel YEAR Function.

Generic Formula

=YEAR(date)

The YEAR Function operates by taking one criteria, the date from which you want to extract the year, and extracts the year from it.

How to use the Excel YEAR Function.

We are going to demonstrate the usage of the YEAR Function in 3 simple steps.

  1. Label the columns of our worksheet and assign a blank cell for Excel to determine the year number.

See example illustrated below;;

Figure 2. Get Year From Date in Excel.

  1. Enter the formula for the YEAR Function into the formula bar for cell D2, to generate the year number from our date list in cell A2.

The modified YEAR formula is as follows;

=YEAR(A2)

Figure 3. YEAR Function in Excel.

  1. Modify, copy and paste the formula in cell D2 above into the other cells in the YEAR column to get the desired results.

Figure 4. YEAR Function in Excel.

Note

  • The dates entered in our date list have to appear in a form recognized as valid by Excel.
  • Making use of dates in the form of text will only cause unpredictable results due to different regional date settings on our computers.

Figure 5. Final Result

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc