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.
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.
- 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.
- 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;
Figure 3. YEAR Function in Excel.
- 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.
- 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.