{"id":2372,"date":"2022-05-19T21:42:09","date_gmt":"2022-05-19T16:12:09","guid":{"rendered":"https:\/\/sheetstips.com\/?p=2372"},"modified":"2022-05-23T12:59:16","modified_gmt":"2022-05-23T07:29:16","slug":"how-to-extract-year-from-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/how-to-extract-year-from-google-sheets\/","title":{"rendered":"How to Extract the Year from Google Sheets-YEAR Function in Google Sheets"},"content":{"rendered":"<p>There are several functions in Google Sheets that help you perform various actions and operations without any difficulty. Of all the functions, Google Sheets has one of the most useful functions named YEAR. Using the YEAR function in Google Sheets, we can simply extract the year based on the date. To simplify the dataset based on the dates, we can use the YEAR function. For example, let us say you want to know the list of employees who have completed 5 years in your organization. To know the same, you can extract the year of joining just by using the YEAR Function.<\/p>\n<p>Interesting, isn&#8217;t it?<\/p>\n<p>This is an example. With the help of the YEAR function, we can do many more things. But it is extremely important for one to know how to extract the year for any given dataset. And hence, here is an article that talks everything about how to extract a year in the spreadsheet using <strong><a href=\"https:\/\/sheetstips.com\/\" target=\"_blank\" rel=\"noopener\">Google Sheets Tips.<\/a><\/strong> Read further to find out more.<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#Syntax-of-the-YEAR-Function-in-Google-Sheets\">Syntax of the YEAR Function in Google Sheets<\/a><\/li>\n<li><a href=\"#How-to-Extract-Years-in-Google-Sheets-Using-the-YEAR-Function?\">How to Extract Years in Google Sheets Using the YEAR Function?<\/a><\/li>\n<li><a href=\"#How-to-Extract-the-Year-from-a-Date-using-the-RIGHT-Function?\">How to Extract the Year from a Date using the RIGHT Function?<\/a><\/li>\n<li><a href=\"#How-to-Extract-Year-Using-the-TEXT-Function-in-Google-Sheets?\">How to Extract Year Using the TEXT Function in Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Extract-Year-Using-the-Query-Function?\">How to Extract Year Using the Query Function?<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"Syntax-of-the-YEAR-Function-in-Google-Sheets\">Syntax of the YEAR Function in Google Sheets<\/h2>\n<p>In order to use the YEAR function in Google Sheets, it is extremely important for one to know the syntax of the same and how to use it in Google Sheets. So let us first understand the syntax of the YEAR function in Google Sheets.<\/p>\n<p><strong><span style=\"color: #ff0000;\">=YEAR (Date)<\/span><\/strong><\/p>\n<p>A date is a date value or a cell carrying a date from which the year value in YYYY format should be extracted. As an input to this function, you may also use functions that return a date or a number.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/query-function-google-sheets\/\">Google Sheets QUERY Function Explained With Examples<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/convert-text-to-date-in-google-sheets\/\" data-origin=\"2372\" data-position=\"1\">How to Convert Text to Date in Google Sheets? (With Examples)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/regexextract-google-sheets\/\">How to use REGEXEXTRACT Function in Google Sheets?(With Examples)<\/a><\/li>\n<\/ul>\n<h3 id=\"How-to-Extract-Years-in-Google-Sheets-Using-the-YEAR-Function?\">How to Extract Years in Google Sheets Using the YEAR Function?<\/h3>\n<p>The steps to extract the year of any given dataset using the YEAR function are outlined below:<\/p>\n<ul>\n<li><strong>1st Step:<\/strong> Launch the Google Spreadsheet.<\/li>\n<li><strong>2nd Step:<\/strong> Now move to the date values from where you would like to extract the year.<\/li>\n<li><strong>3rd Step:<\/strong> Enter the formula &#8220;<strong>=Year(Cell Range)<\/strong>&#8220;. In this example, the cell range is A2. Hence my formula is =Year(A2).<\/li>\n<li><strong>4th Step:<\/strong> You will see the Year being extracted. Now drag the formula applied cell to the other parts of the cell to extract the year and you will see the results as shown in the image below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2377 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function.png\" alt=\"extract-year in google sheets\" width=\"339\" height=\"278\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function.png 339w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function-300x246.png 300w\" sizes=\"(max-width: 339px) 100vw, 339px\" \/><\/p>\n<h3 id=\"How-to-Extract-the-Year-from-a-Date-using-the-RIGHT-Function?\">How to Extract the Year from a Date using the RIGHT Function?<\/h3>\n<p>Follow the steps listed below to extract the year using the RIGHT function.<\/p>\n<ul>\n<li><strong>1st Step:<\/strong> Open the Google Spreadsheet on your device.<\/li>\n<li><strong>2nd Step:<\/strong> Move to the cell where you want to extract the year.<\/li>\n<li><strong>3rd Step:<\/strong> Type the formula &#8220;<strong>=right (A2,4)<\/strong>&#8220;.<\/li>\n<li><strong>4th Step:<\/strong> Press the &#8220;<strong>Return<\/strong>&#8221; key and you will find the results.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2376 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function1.png\" alt=\"extract-year in google sheets\" width=\"305\" height=\"244\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function1.png 305w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function1-300x240.png 300w\" sizes=\"(max-width: 305px) 100vw, 305px\" \/><\/p>\n<p>In the RIGHT function, we are giving the command to extract the right-side characters of the cells. Following that, in the RIGHT function, we should also specify how many characters it should extract.<\/p>\n<ul>\n<li class=\"jp-relatedposts-post-title\"><a class=\"jp-relatedposts-post-a\" title=\"How To Insert Indents in Google Sheets? &amp;#8211; Know How to Tab Down in Google Sheets\" href=\"https:\/\/sheetstips.com\/how-to-insert-indents-in-google-sheets\/?relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=2&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=2&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=2\" data-origin=\"2372\" data-position=\"2\">How To Insert Indents in Google Sheets? \u2013 Know How to Tab Down in Google Sheets<\/a><\/li>\n<li class=\"jp-relatedposts-post-title\"><a class=\"jp-relatedposts-post-a\" title=\"Row and Rows in Google Sheets: Know How Many Rows Are There in Google Sheets\" href=\"https:\/\/sheetstips.com\/row-and-rows-in-google-sheets\/?relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=1\" data-origin=\"2372\" data-position=\"1\">Row and Rows in Google Sheets: Know How Many Rows Are There in Google Sheets<\/a><\/li>\n<li class=\"jp-relatedposts-post-title\"><a class=\"jp-relatedposts-post-a\" title=\"How to\u00a0Make an\u00a0Organization Chart in Google Sheets? &amp;#8211; Create an Org Chart in Google Sheets\" href=\"https:\/\/sheetstips.com\/how-to-make-an-organization-chart-in-google-sheets\/?relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0&amp;relatedposts_hit=1&amp;relatedposts_origin=2372&amp;relatedposts_position=0\" data-origin=\"2372\" data-position=\"0\">How to\u00a0Make an\u00a0Organization Chart in Google Sheets? \u2013 Create an Org Chart in Google Sheets<\/a><\/li>\n<\/ul>\n<h3 id=\"How-to-Extract-Year-Using-the-TEXT-Function-in-Google-Sheets?\">How to Extract Year Using the TEXT Function in Google Sheets?<\/h3>\n<p>Apart from the above methods, the TEXT function is also one of the easiest methods which help us to extract the year in Google Sheets. The steps to extract the year from the given dates using the TEXT function are given below:<\/p>\n<ul>\n<li><strong>1st Step:<\/strong> Open the Google Sheets to extract the year.<\/li>\n<li><strong>2nd Step:<\/strong> Move to the cell from where you want to extract the year from the given dates.<\/li>\n<li><strong>3rd Step:<\/strong> Enter the formula &#8220;<strong>=TEXT(A2, YYYY)<\/strong>&#8220;. A2 refers to the cell range.<\/li>\n<li><strong>4th Step:<\/strong> Press the &#8220;<strong>Return<\/strong>&#8221; key and you will find the results as shown in the image given below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2375 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function2.png\" alt=\"extract-year in google sheets\" width=\"323\" height=\"276\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function2.png 323w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function2-300x256.png 300w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/p>\n<h3 id=\"How-to-Extract-Year-Using-the-Query-Function?\">How to Extract Year Using the Query Function?<\/h3>\n<p>We can also extract the year from the dates simply by using the QUERY function in Google Sheets. The steps to year extraction in a spreadsheet using the QUERY function are explained below.<\/p>\n<ul>\n<li><strong>1st Step:<\/strong> Open the Google Spreadsheet.<\/li>\n<li><strong>2nd Step:<\/strong> Move to the cell where you want to extract the year from the provided dates.<\/li>\n<li><strong>3rd Step:<\/strong> Enter the formula &#8220;<strong>=QUERY (A2:A4, &#8220;SELECT YEAR (A)&#8221;)<\/strong>&#8220;.<\/li>\n<li><strong>4th Step:<\/strong> Press the &#8220;<strong>Enter<\/strong>&#8221; key and you will fill in the results as shown in the image given below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2374 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function3.png\" alt=\"extract-year in google sheets\" width=\"445\" height=\"243\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function3.png 445w, https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/05\/YEAR-function3-300x164.png 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several functions in Google Sheets that help you perform various actions and operations without any difficulty. Of all the functions, Google Sheets has one of the most useful functions named YEAR. Using the YEAR function in Google Sheets, we can simply extract the year based on the date. To simplify the dataset based &#8230; <a title=\"How to Extract the Year from Google Sheets-YEAR Function in Google Sheets\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/how-to-extract-year-from-google-sheets\/\" aria-label=\"More on How to Extract the Year from Google Sheets-YEAR Function in Google Sheets\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":822,"url":"https:\/\/sheetstips.com\/query-function-google-sheets\/","url_meta":{"origin":2372,"position":0},"title":"Google Sheets QUERY Function Explained With Examples","author":"Varsha","date":"May 17, 2022","format":false,"excerpt":"Query Function in Google Sheets helps us to extract the specific set of data from a tabular column. For example, let's say you have a huge employee dataset of your company and you would like to view only marketing team details. In this case, you can use the Query Function\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"query function in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/query-function-in-google-sheets4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2717,"url":"https:\/\/sheetstips.com\/extract-quarter-in-google-sheets\/","url_meta":{"origin":2372,"position":1},"title":"How To Extract Quarter in Google Sheets? &#8211; Quarter Function in Google Sheets","author":"Varsha","date":"May 28, 2022","format":false,"excerpt":"Getting a quarter value from the given date can be quite tricky in Google Sheets since it does not have any inbuilt functions. However, with the help of a few in-built functions and formulas, we can easily extract the quarter value in Google Sheets. If you are looking to extract\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"extract-quarter","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/extract-quarter3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2041,"url":"https:\/\/sheetstips.com\/subtotal-function-in-google-sheets\/","url_meta":{"origin":2372,"position":2},"title":"Subtotal Function in Google Sheets &#8211; How to Subtotal in Google Sheets?","author":"Varsha","date":"May 22, 2022","format":false,"excerpt":"The Google Sheets Subtotal function will enable users to subtotal the vertical range of cells using a specified aggregation function.\u00a0A total of 11+ functions are available in Google Spreadsheet, with the help of which we can perform the subtotal operation.\u00a0On this page, let us understand how to perform a subtotal\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"SUBTOTAL function in Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/01\/subtotal-function-in-google-sheets3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1062,"url":"https:\/\/sheetstips.com\/filter-function-google-sheets\/","url_meta":{"origin":2372,"position":3},"title":"How to Use Filter Functions in Google Sheets with Examples","author":"Varsha","date":"December 2, 2022","format":false,"excerpt":"Google Sheets comes with various functions such as VLOOKUP, IMPORTRANGE, REGXREPALCE, and so on. The FILTER function is one such amazingly strong one where we can perform various options without using the FILTER Views. On this page, let's learn everything about Filter Functions and operations that can be performed with\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"filter-function-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/filter-functions-google-sheets3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":992,"url":"https:\/\/sheetstips.com\/convert-text-to-date-in-google-sheets\/","url_meta":{"origin":2372,"position":4},"title":"How to Convert Text to Date in Google Sheets? (With Examples)","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"In Google Sheets, we have n number of options to represents dates. However, in a few instances, the Dates will be understood as text when we are importing files to Google Sheets.\u00a0 And thus if we want to perform some operations with Dates in Google Sheets, it will lead to\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":137,"url":"https:\/\/sheetstips.com\/count-non-blank-cells-google-sheets\/","url_meta":{"origin":2372,"position":5},"title":"How to Count Cells If Not Blank in Google Sheets","author":"Varsha","date":"May 20, 2022","format":false,"excerpt":"Google Sheets If Not Blank: It is really difficult for one to find the cells which are not blank\u00a0 in the numerous datasets mannually. To find the non blank cells in the given dataset on Google sheet, one can make use of Google Sheet count functions. The Count functions of\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Count-Cells-If-Not-Blank-in-Google-Sheets-Countif","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Count-Cells-If-Not-Blank-in-Google-Sheets-Countif-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2372"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=2372"}],"version-history":[{"count":5,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2372\/revisions"}],"predecessor-version":[{"id":2643,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/2372\/revisions\/2643"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=2372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=2372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=2372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}