In Excel 2013, there is a new Timeline filter (slicer) that allows you to easily select a range of dates over which you want to filter your data. The feature is very slick. Here's an picture: I wanted to use this slicer in an Analysis Services demo...