How to Group Dates in Excel Slicer (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

We can easily visualize data if we group them. This can save us a ton of time. There are many ways to group Dates. We will show you 4 ways to group Dates in Excel Slicer.


How to Group Dates in Excel Slicer: 4 Handy Approaches

To demonstrate our methods, we have selected a dataset with 3 columns: “Name”, “Sales”, and “Date”. Our goal is to group the data using the Dates.

how to group dates in excel slicer Intro


1. Use PivotTable Analyze to Group Dates in Excel Slicer

We will convert our data to a Pivot Table for the first method. Then, we will use a Slicer from the PivotTable Analyze tab, we add a Slicer to group Dates.

Steps:

  • To begin with, we will create a PivotTable.
  • Then, select the cell range B4:D13.
  • Next, from the Insert tab >>> select PivotTable.
  • So, the “PivotTable from table or range” dialog box will pop up.
  • Afterward, select “Existing Worksheet” and cell B15 as the output location.
  • Then, press OK.

  • Thus, it will create an empty PivotTable. Moreover, for more clarity, we have moved the PivotTable Fields box closer to our PivotTable.

how to group dates in excel slicer PivotTable

  • After that, we will add fields to our Table.
  • So, just click on the three fields – “Name”, “Sales”, and “Date”.
  • Then, Excel will automatically arrange those fields in the PivotTable. In case, yours is not in the right Columns or Rows or Values areas; you can drag and drop the fields to re-allocate them.
  • Next, what our PivotTable looks like, we can see it side by side.

  • Up to this point, the steps are the same for methods 2 and 3. Hence, we will refer to this section.

Then, we will add Slicer in Excel.

  • First, we need to select anywhere inside our PivotTable.
  • Then, from the PivotTable Analyze tab >>> select Insert Slicer.

how to group dates in excel slicer Insert

  • So, the Insert Slicers box will appear.
  • Then, select Date and press OK.

  • Therefore, we can see the Date Slicer.

how to group dates in excel slicer Window

  • Lastly, select “March 1, 2022” in the Slicer, to group Dates in Excel.

Read More: How to Make Excel Slicer with Search Box


2. Apply PivotTable Fields to Group Dates in Excel Slicer

Now, this method is similar to the first method. We will add the Slicer from the PivotTable Fields this time around.

Steps:

  • As shown in the first method, bring up the PivotTable.
  • Next, right-click on the Date field and bring the Context Menu.
  • Then, select Add as Slicer.

how to group dates in excel slicer Approach 2

  • By doing so, it will add the Slicer.
  • Lastly, select “March 3, 2022” to group Dates in the Excel Slicer.

how to group dates in excel slicer


3. Use of Timelines to Group Dates in Excel Slicer

In this section, we will use the Timeline feature to group Dates in Excel. A timeline is just like a Slicer, however, the Timeline is specifically created for Dates. Remember, this feature is only available in Excel version 2013 and later.

Steps:

  • As shown in the first method, bring up the PivotTable.
  • First, we need to select anywhere inside our PivotTable.
  • Then, from the PivotTable Analyze tab >>> select Insert Timeline.

  • Then, a dialog box will appear.
  • Afterward, select Date and press OK.

how to group dates in excel slicer Insert Menu

  • After that, the Date Timeline will be set as MONTHS.
  • So, click on that Drop Down List and select DAYS.

  • Then, select the date “March 1, 2022” to group the Dates using Excel Timeline.

how to group dates in excel slicer 2

Read More: How to Create Timeline Slicer with Date Range in Excel


4. Add Slicer into Table to Group Dates

For the last method, we will convert our dataset into a normal table. Then, we will add a Slicer from the Table Design tab to group Dates.

Steps:

  • First, select the cell range B4:D13.
  • Then, from the Insert tab >>> select Table.
  • So, the “Create Table” dialog box will pop up.
  • Next, select “My table has headers”, if it is not selected by default.
  • Afterward, press OK.

  • Then, we will see Filter triangles indicating our dataset is now a table.
  • Next, select anywhere inside the table.

how to group dates in excel slicer Table

  • After that, from the Table Design tab >>> select Insert Slicer.

  • Again, the Insert Slicer dialog box will appear.
  • Then, select Date and press OK.

how to group dates in excel slicer Slicer Again

  • Lastly, if you click on any of the Slicers, then it will group the Dates.


Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

how to group dates in excel slicer Practice


Download Practice Workbook


Conclusion

We have shown you 4 handy approaches to how to group Dates in Excel Slicer. If you face any problems regarding these methods or have any feedback for me, feel free to comment below.

Thanks for reading, keep excelling!


Related Articles


What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo