{"id":490806,"date":"2022-09-06T22:00:00","date_gmt":"2022-09-06T19:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/"},"modified":"2022-09-06T22:00:00","modified_gmt":"2022-09-06T19:00:00","slug":"how-to-get-the-month-or-year-from-a-date-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/","title":{"rendered":"#How to Get the Month or Year From a Date in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2fc1d308d34\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2fc1d308d34\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/#%E2%80%9CHow_to_Get_the_Month_or_Year_From_a_Date_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Get the Month or Year From a Date in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/#Get_the_Month_or_Year_With_Date_Functions\" >Get the Month or Year With Date Functions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/#Get_the_Month_or_Year_With_the_TEXT_Function\" >Get the Month or Year With the TEXT Function<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Get_the_Month_or_Year_From_a_Date_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Get the Month or Year From a Date in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<figure style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage size-full wp-image-821225\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/calendar-pins-office.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A calendar next to several colorful thumbtacks on a purple surface.\" width=\"1200\" height=\"675\"\/><figcaption class=\"wp-caption-text\"><span class=\"type:primaryImage imagecredit\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.shutterstock.com\/image-photo\/close-calendar-pin-on-purple-table-2182414563\">Chutima Chaochaiya\/Shutterstock.com<\/a><\/span><\/figcaption><\/figure>\n<p>Dates in Microsoft Excel are useful for tracking finances, orders, and sales. So, there may come a time when you want to pull a month or year out of a date entry. Functions and formulas make this an easy task.<\/p>\n<p>There are a couple of ways to get a month from a date in Excel, depending on if you want to display the result as a number, word, or abbreviation. And luckily, you can use these same methods to get the year from your date entry.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Get_the_Month_or_Year_With_Date_Functions\"><\/span>Get the Month or Year With Date Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to get the numeric value for a month such as 10 for October, 11 for November, and so on, the MONTH function gets the job done quickly. For years, you can simply use the YEAR function and a reference.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove a Year from a Date in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for each function is the same: <code>MONTH(reference)<\/code> and <code>YEAR(reference)<\/code> where you refer to the cell containing the date.<\/p>\n<p>You can use the following formulas to get the month and then the year from the date in cell A2:<\/p>\n<pre>=MONTH(A2)<\/pre>\n<pre>=YEAR(A2)<\/pre>\n<p>You\u2019ll then see the result in the cell containing the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820737\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FullYear-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"YEAR function to obtain the year from a date\" width=\"415\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Remember, the month is formatted as its numeric value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820736\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MonthNumber-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"MONTH function to obtain the month from a date\" width=\"445\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have a list of dates where you want to grab the month and\/or year for each entry, use the fill handle to drag the formula(s) down to the remaining cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820738\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/CopyFullFormulas-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copy formula to cells using the fill handle\" width=\"650\" height=\"282\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Get_the_Month_or_Year_With_the_TEXT_Function\"><\/span>Get the Month or Year With the TEXT Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you prefer to see the name of the month or an abbreviation rather than the number. You can do this for the month using the TEXT function. You can also get the two-digit number for the year with this method.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find the Day of the Week From a Date in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>TEXT(value, format_code)<\/code> where you\u2019ll need both arguments to display the month. The <code>value<\/code> is the cell containing the date and the <code>format_code<\/code> is how you want to display the result.<\/p>\n<p>Here, we\u2019ll get the month for the date in cell A2 as a full word using the letter M for month as the <code>format_code<\/code>:<\/p>\n<pre>=TEXT(A2,\"mmmm\")<\/pre>\n<p>Note, you need at least four M\u2019s within quotation marks to get the full month name. The number of letters in the month\u2019s name does not correspond to the number of M\u2019s in the argument; just enter at least four of them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820739\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FullMonth-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Full month name using the TEXT function\" width=\"490\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To get the three-letter abbreviation for a month instead of the full name, just use three M\u2019s:<\/p>\n<pre>=TEXT(A3,\"mmm\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820740\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/ShortMonth-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Abbreviation for month name using the TEXT function\" width=\"470\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use the TEXT function if you only want two digits for the year rather than all four. You\u2019ll use the letter Y for year as the <code>format_code<\/code>:<\/p>\n<pre>=TEXT(A2,\"yy\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820741\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/ShortYear-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Two digits for the year using the TEXT function\" width=\"445\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Again, you can use the fill handle to copy the formula(s) down to your remaining cells if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-820742\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/CopyShortFormulas-ExcelMonthYearFromDate.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copied formulas to cells using the fill handle\" width=\"470\" height=\"345\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Pulling a month or year out of a full date in Excel takes only a minute with these methods. For more, check out these additional date and time functions in Excel you might find useful.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/820733\/how-to-get-the-month-or-year-from-a-date-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Get the Month or Year From a Date in Microsoft Excel&#8221; Chutima Chaochaiya\/Shutterstock.com Dates in Microsoft Excel are useful for tracking finances, orders, and sales. So, there may come a time when you want to pull a month or year out of a date entry. Functions and formulas make this an easy task&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":490807,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/calendar-pins-office.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-490806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/490806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=490806"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/490806\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/490807"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=490806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=490806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=490806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}