{"id":5054,"date":"2020-12-02T16:38:31","date_gmt":"2020-12-02T15:38:31","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5054"},"modified":"2024-03-22T18:55:18","modified_gmt":"2024-03-22T17:55:18","slug":"group-month-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/","title":{"rendered":"Group By Month, Year &amp; Week With Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33506\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables-1024x576.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/12\/Group-By-Month-Year-Week-With-Excel-Pivot-Tables.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><\/p>\n<p>Before I was a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table<\/a> guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year.<\/p>\n<p><strong>Group Dates in Pivot Table would take a ton of effort using <a class=\"wpil_keyword_link\" title=\"Formulas\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Formulas<\/a><\/strong>:<\/p>\n<ul>\n<li>Extracting the month and year from\u00a0each transactional date;<\/li>\n<li>Then manually grouping them together to get the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-total-sales-with-an-array-formula-excel\/\" target=\"_blank\" rel=\"noopener\">total sales<\/a> numbers for each month. \u00a0PAINFUL &amp; SLOW!<\/li>\n<\/ul>\n<p>Thankfully there\u00a0is the Pivot Table way (I wish I had known this back then), which is quick and reduces the risks of making any errors&#8230;.ah yeah &amp; I almost forgot, it is also<strong> easy to add new data to your sales report<\/strong> with a simple Refresh!<\/p>\n<p>Let&#8217;s look at each one of these!<\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Group_Dates_in_Pivot_Table_by_Month_Year\" title=\"Group Dates in Pivot Table by Month &amp; Year\">Group Dates in Pivot Table by Month &amp; Year<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Group_Dates_in_Pivot_Table_by_Week\" title=\"Group Dates in Pivot Table by Week\">Group Dates in Pivot Table by Week<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Change_Formatting\" title=\"Change Formatting\">Change Formatting<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Summarize_Value_by\" title=\"Summarize Value by\">Summarize Value by<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Ungroup_Dates\" title=\"Ungroup Dates\">Ungroup Dates<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Control_Automatic_Grouping\" title=\"Control Automatic Grouping\">Control Automatic Grouping<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-month-excel-pivot-tables\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Group_Dates_in_Pivot_Table_by_Month_Year\"><\/span><span style=\"color: #339966\"><a id=\"group-dates-in-pivot-table-by-month-year\"><\/a>Group Dates in Pivot Table by Month &amp; Year<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the data below, you can see that there are <strong>two columns<\/strong>: one that contains the <strong>transaction date<\/strong> of the sale, and the second column contains the<strong> total sales amount<\/strong> for a particular date.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21748\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"232\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png 232w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM-138x300.png 138w\" sizes=\"(max-width: 232px) 100vw, 232px\" \/><\/a><\/p>\n<h3><em><strong>Want to know How To Group Dates in Pivot Table by Month<\/strong><strong>?<\/strong><\/em><\/h3>\n\n<p>In the example below, I show you how to Pivot Table Group by Month:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Group-by-Month.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Group-by-Month.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p><span style=\"color: #339966\"><strong>STEP 1: <\/strong><\/span><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-table\/\" target=\"_blank\" rel=\"noopener\">Insert a new Pivot table<\/a> by clicking\u00a0on your data and going\u00a0to<strong><em>\u00a0Insert &gt; Pivot Table &gt; New Worksheet or Existing Worksheet<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5058\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-01.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"386\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-01.png 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-01-300x267.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong><\/span>\u00a0In the\u00a0<strong>ROWS<\/strong>\u00a0section put in the\u00a0<em><strong>Order Date <\/strong><\/em>field.<\/p>\n<p>Notice that in Excel 2016 (the version that I am using) it will <strong>automatically Group<\/strong> the <strong><em>Order Date <\/em><\/strong><em>into Years &amp; Quarters<\/em>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5059\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-02.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-02.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-02-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3: <\/strong><\/span>Right-click on any row in your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/errors-when-grouping-by-dates-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table and select\u00a0Group<\/a> so we can select our Group order that we want:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5060\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-03.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"350\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-03.png 350w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-03-226x300.png 226w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4: <\/strong><\/span>We need to deselect\u00a0<strong>Quarters\u00a0<\/strong>and make sure only <b>Months <\/b>and<b> Years\u00a0<\/b>are\u00a0selected (which will be highlighted in blue).<\/p>\n<p>This will group our dates by the <em><strong>Months <\/strong><\/em>and <em><strong>Years<\/strong><\/em>. \u00a0Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5061\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-04.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"235\" height=\"307\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-04.png 235w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-04-230x300.png 230w\" sizes=\"(max-width: 235px) 100vw, 235px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 5:<\/strong><\/span> In the\u00a0<strong>VALUES <\/strong>area\u00a0put in the\u00a0<strong><em>Sales\u00a0<\/em><\/strong>field. \u00a0This will get the total of the Sales for each Month\u00a0&amp; Year:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5062\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-05.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-05.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-05-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>This is how you can easily create <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-dates-with-a-pivot-table\/\" target=\"_blank\" rel=\"noopener\">Pivot Table Group Dates<\/a> by Month!<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5063\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"181\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png 181w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06-132x300.png 132w\" sizes=\"(max-width: 181px) 100vw, 181px\" \/><\/a><\/p>\n<div>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Group_Dates_in_Pivot_Table_by_Week\"><\/span><span style=\"color: #339966\"><strong><a id=\"group-dates-in-pivot-table-by-week\"><\/a>Group Dates in Pivot Table by Week<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To group the dates by week, follow the steps below:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong><\/span><strong> Right-click<\/strong> on one of the dates and select <strong>Group<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21760\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"413\" height=\"452\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921.png 413w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-274x300.png 274w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong><\/span> Select the<strong> day option from the list<\/strong> and deselect other options.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-926.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21761\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-926.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"235\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-926.png 235w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-926-229x300.png 229w\" sizes=\"(max-width: 235px) 100vw, 235px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong><\/span> In the Number of days section, <strong>type 7<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-922.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21762\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-922.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"236\" height=\"309\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-922.png 236w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-922-229x300.png 229w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/a><\/p>\n<p>This is how the <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-date-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">group dates in Pivot Table by week<\/a><\/strong> will be displayed.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-923.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21763\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-923.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"404\" height=\"456\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-923.png 404w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-923-266x300.png 266w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong><\/span> You can even change the starting date to 01-01-2012 in the section below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-924.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21764\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-924.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"236\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-924.png 236w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-924-230x300.png 230w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Your final grouped data is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-925.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21765\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-925.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"377\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-925.png 377w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-925-259x300.png 259w\" sizes=\"(max-width: 377px) 100vw, 377px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Change_Formatting\"><\/span><span style=\"color: #339966\"><a id=\"change-formatting\"><\/a>Change Formatting<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div>\n<div>\n<p>Now we have our sales numbers grouped by Month &amp; Years, notice that <strong>we can improve the formatting<\/strong> by following the steps below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5063\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"181\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06.png 181w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-06-132x300.png 132w\" sizes=\"(max-width: 181px) 100vw, 181px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong><\/span>Click the <strong>Sum of SALES<\/strong> and select\u00a0<strong>Value Field Settings<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5064\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-07.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"393\" height=\"638\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-07.png 393w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-07-185x300.png 185w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2: <\/strong><\/span>Select\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-number-formatting\/\" target=\"_blank\" rel=\"noopener\">Number Format<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5065\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-08.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-08.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-08-300x257.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3: <\/strong><\/span>Select\u00a0<strong>Currency.\u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5066\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-09.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"529\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-09.png 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-09-300x264.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You\u00a0now have your total sales for each monthly\u00a0period! \u00a0Quick &amp; Easy!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5067 size-full\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-10.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"233\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-10.png 233w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Group-by-Month-10-137x300.png 137w\" sizes=\"(max-width: 233px) 100vw, 233px\" \/><\/a><\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Summarize_Value_by\"><\/span><span style=\"color: #339966\"><a id=\"summarize-value-by\"><\/a>Summarize Value by<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the previous examples, you saw how to get total sales by month, year, or week. You can even <strong>calculate the total number of sales<\/strong> that occurred in a particular month, year, or week.<\/p>\n<p>Let&#8217;s look at an example to know how:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1:<\/strong><\/span> <strong>Right-click<\/strong> anywhere on the Pivot Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21770\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944-Copy.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"468\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944-Copy.png 468w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944-Copy-294x300.png 294w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2:<\/strong><\/span> Select<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-field-and-value-settings-in-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Value Field Settings<\/a><\/strong> from the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21771\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"468\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944.png 468w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-944-294x300.png 294w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong><\/span> In the Value Field Setting dialog box, select <strong>Count<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-946.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21772\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-946.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"374\" height=\"320\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-946.png 374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-946-300x257.png 300w\" sizes=\"(max-width: 374px) 100vw, 374px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong><\/span> Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-948.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21773\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-948.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"373\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-948.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-948-300x258.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will<strong> summarize the values as a count<\/strong> of sales instead of the sum of sales (like before).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-947.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21774\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-947.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"259\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-947.png 259w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-947-172x300.png 172w\" sizes=\"(max-width: 259px) 100vw, 259px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ungroup_Dates\"><\/span><span style=\"color: #339966\"><strong><a id=\"ungroup-dates\" style=\"color: #339966\"><\/a>Ungroup Dates<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To ungroup dates in a Pivot Table, simply <strong>right-click on the dates column and select ungroup<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-927.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21766\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-927.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"358\" height=\"427\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-927.png 358w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-927-252x300.png 252w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p>Or, you can go to the <strong>PivotTable Analyze tab and select Ungroup<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-928.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21767\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-928.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"866\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-928.png 866w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-928-300x44.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-928-768x114.png 768w\" sizes=\"(max-width: 866px) 100vw, 866px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Once this is done, the data will be ungrouped again.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21748\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"232\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM.png 232w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-2020-11-29-at-10.53.56-PM-138x300.png 138w\" sizes=\"(max-width: 232px) 100vw, 232px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Control_Automatic_Grouping\"><\/span><span style=\"color: #339966\"><a id=\"control-automatic-grouping\"><\/a>Control Automatic Grouping<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you wish to, you can easily <strong>turn off this automatic date grouping feature in Excel 2016<\/strong>. To do that, follow the steps below:<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 1: <\/strong><\/span>Go to <strong>File Tab<\/strong> &gt; <strong>Options<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-919.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21752\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-919.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"181\" height=\"715\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-919.png 181w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-919-76x300.png 76w\" sizes=\"(max-width: 181px) 100vw, 181px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 2: <\/strong><\/span>In the Excel Options dialog box, click <strong>Data<\/strong> in the categories on the left.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-21753 size-full\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-Copy-e1606677601790.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"824\" height=\"286\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-Copy-e1606677601790.png 824w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-Copy-e1606677601790-300x104.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-Copy-e1606677601790-768x267.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 3:<\/strong><\/span> Check <strong>Disable automatic grouping of Date\/Time columns in PivotTables<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21754\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"829\" height=\"681\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy.png 829w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-920-Copy-768x631.png 768w\" sizes=\"(max-width: 829px) 100vw, 829px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966\"><strong>STEP 4:<\/strong><\/span> Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-Copy-Copy-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21756\" title=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-Copy-Copy-1.png\" alt=\"Group By Month, Year &amp; Week With Excel Pivot Tables\" width=\"829\" height=\"681\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-Copy-Copy-1.png 829w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-Copy-Copy-1-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/11\/Screenshot-921-Copy-Copy-1-768x631.png 768w\" sizes=\"(max-width: 829px) 100vw, 829px\" \/><\/a><\/p>\n<p>This will easily turn off the automatic grouping feature in the Pivot Table! So, the date will be <strong>not be grouped automatically now when you drag the date field to an area<\/strong> in the pivot table.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #339966\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can <strong>easily <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\">analyze data<\/a><\/strong> by week, month, year, days, hour, etc., and find trends using this grouping dates feature in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Pivot Table<\/a>. It is a fairly simple and super quick method to group dates.<\/p>\n<p>Did you know there are many creative ways of doing grouping in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/month-over-month\/\" target=\"_blank\" rel=\"noopener\">Excel Pivot Tables<\/a>?<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/group\/\" target=\"_blank\"><strong>Learn all about it here<\/strong><\/a>!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-by-fiscal-years-quarters\/\" target=\"_blank\" rel=\"noopener\">Group by Fiscal Years &amp; Quarters<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-by-sales-range\/\" target=\"_blank\" rel=\"noopener\">Group by Sales Range in Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/group-by-text-fields-in-pivot-table\/\" target=\"_blank\" rel=\"noopener\">Group by Text fields in Excel Pivot Tables<\/a><\/li>\n<\/ul>\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Group Dates in Pivot Table would take a ton of effort using Formulas: Extracting the month and year from\u00a0each transactional date; Then manually grouping them together [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":33506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Group By Month, Year &amp; Week With Excel Pivot Tables","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,18],"tags":[199,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5054"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=5054"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33506"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}