Use the Excel filtering capability for dates

- [Instructor] We're looking at a worksheet … that's showing sales over a two year period. … About 400 rows or so. … And we want to analyze the data … based on date type information. … Let's apply a filter here. … Going to the Data tab, filter arrow to the right, … we see filter arrows on each column. … Excel recognizes the nature of the data. … If we click the filter arrow for column A, … we see text filters appearing. … Column C we see, clicking that same relative arrow, … number filters. … And sure enough, clicking column D, the drop arrow, … we see date filters. … Quite a bit different than the other list. … And by the way, for time, nothing special there. … Excel simply is seeing these as numbers. … But let's focus on date drop arrow. … This is historical data, it's for a two year period. … If we go to date filters, depending upon how recent … the data is, we might want to be looking at the last quarter … of the last year in this data, or last year. … And you can imagine if this were planning type data, …