Go Back

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:
Here are some problems that our users have asked and received explanations on

UNABLE TO EXTRACT YEAR FROM DATE USING YAER FUNCTION
Solved by Z. W. in 29 mins
I need help to get a date in say column B, if a date in column A is within a fiscal year
Solved by E. H. in 28 mins
I need help with the following: Sales: Year-to-date. For each Rep Group, summarize year-to-date sales (ending in the month selected) compared to year-to-date sales (ending the same month in the year prior to the selected year). For example, if June and 2018 are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018Jun 2018, with year-to-date sales from Jan 2017Jun 2017. Hint: For example, how will using the number of the month instead of the name of the month help you create a formula to easily summarize all sales ending in June (month 6)? Average Unit Price: Year-to-date. For each Rep Group, summarize average year-to-date unit price (ending in the month selected) compared to average year-to-date unit price (ending the same month in the year prior to the selected year). For example, if June and 2018 are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018Jun 2018 with year-to-date sales from Jan 2017Jun 2017.
Solved by Z. S. in 26 mins

Leave a Comment

avatar