Inside Microsoft Excel

Stop scrolling! Display only the data that falls between two dates

Inside Microsoft Excel

by Kara Soos

There’s another way to filter your data by dates that applies to the above situation. The answer is the Advanced Filter feature. With this method, you can include only the dates that fall between two specific dates in your filter. We’ll use Mr. Fielding’s example and filter the list of employees for those with hire dates falling between 5/14/04 and 6/28/04, as shown inĀ Figure A.

To filter our data by a specific range[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)