From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Automatic date grouping

Automatic date grouping - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Automatic date grouping

“

- [Instructor] All right, I want to take a minute or two talk about date grouping, specifically, 'cause it looks a little bit different from the exercise that we just walked through. And the reason for that, is that in recent years, believe 2016 or 2013, Excel started to integrate some capabilities to automatically detect date fields and create groupings and hierarchies behind the scenes without any input from the user, which can certainly be helpful but it's also a little bit confusing if you don't know what's going on. So let me show you an example. We're going to start by just clearing this Title, our label filter that we put in place. And I'm going to drag Title out of the pivot table. And what we're going to do here is pull in the Release Date fields. But before we do, I want to dive into that Movie Database raw data tab and just get a sense of exactly what that column's formatted like. So Release Date here in column B. I've got data at the daily level, so April 15th, 1935…

Contents