Table of Contents
To extract a year from a date in Google Sheets, one can use the YEAR function. This function takes the date as an input and returns the year as an output. For example, to extract the year from a date of May 13th, 2016, you would enter “=YEAR(5/13/2016)” into the sheet and the output would be 2016.
You can use the following formula to extract the year from a date in Google Sheets:
=YEAR(A1)
This particular formula will return the year from the date in cell A1.
The following example shows how to use this function in practice.
Example: Extract Year from Date in Google Sheets
Suppose we have the following list of dates in Google Sheets:
We can type the following formula into cell B2 to extract the year from the date in cell A2:
=YEAR(A2)
We can then drag and fill this formula down to each remaining cell in column B:
The values in column B display the year of the date in the corresponding cell in column A.
If you’d like to extract the month along with the year for each date, you can type the following formula into cell B2:
=TEXT(A2, "MMM "&"YYYY")
We can then drag and fill this formula down to each remaining cell in column B:
The values in column B now display the month and year of the date in the corresponding cell in column A.