Table of Contents
To extract the year from a date in Google Sheets, use the “YEAR” formula. This formula takes a date as an input and returns the year as a four-digit number. It is useful for organizing and analyzing data by year, such as in financial or sales reports. To use the formula, simply select the cell where you want the year to appear and type “=YEAR(” followed by the cell containing the date. Press enter to display the year. This formula can also be combined with other formulas and functions to further manipulate and analyze data.
Extract Year from Date in Google Sheets
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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I extract the year from a date in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-extract-the-year-from-a-date-in-google-sheets/
stats writer. "How can I extract the year from a date in Google Sheets?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-extract-the-year-from-a-date-in-google-sheets/.
stats writer. "How can I extract the year from a date in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-extract-the-year-from-a-date-in-google-sheets/.
stats writer (2024) 'How can I extract the year from a date in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-extract-the-year-from-a-date-in-google-sheets/.
[1] stats writer, "How can I extract the year from a date in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I extract the year from a date in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.