Go Back

Get year from date

Read time: 15 minutes

In this tutorial, you will learn how to get a year from date. This is possible by using Excel YEAR function. Above all, you will need to format the cells which contain dates as a date type. Also, it is possible to use text cells in this function, but this can cause errors due to users’ settings, so it is recommended to format all cells as dates. Furthermore, the cells where the formula is applied must be formatted as a number or general, because the function returns a year.

Get year from the date

Formula

=YEAR(date)

Explanation

The YEAR function enables a user to get a year from date. The only parameter of this function is a date cell reference.

Example 1

In the following example we will see how you can use YEAR function to get a year from date:

=YEAR(B3)

 

 

Figure 1. Get a year from the date

As you can see in the picture we have dates in column B (“Date”) for which we want to return a year in column C (“Year”). For the date in cell B3 24-Feb-2018, we will get the year 2018 in the cell C3, as this is the year of the selected date.

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