Tip of the week # 505
16 January 2017


Filter dates by month (Excel 2010 onwards) *

Do you use dates in Excel? If so, you probably at some point have the need to display only those containing relevant information. For example, you might want to filter out all deliveries you are expecting in February. Or all courses planned for March. You can obviously use Excel's Find functionality (CTRL + F) to find a specific date. Or perhaps you use the Date Filters and select, say, Next Month. But did you know you can use the table's Search functionality?

Here's how:

  1. If necessary, create a table. (CTRL + T or CTRL + L, anyone?)
  2. Click on the drop-down arrow of the date's column header.
  3. Click in the Search box and type (part of) your search term. For example, Feb.
  4. Press ENTER.

And no, this isn't relying on you having entered your dates as, say, 16 February 2017. As long as the entries have been formatted as dates, this should work. And remember, there is no need to type the current year if the date you want to enter is part of this year. Simply type, say 16/2. Perhaps have another look at tip 442. (See below.)

Related tips:
Tip 358: Enter the current date and/or time into a worksheet (tip_358.php)
Tip 426: Fast filtering (tip_426.php)
Tip 429: Quickly format and enable filtering of your data (tip_429.php)
Tip 442: Save time entering dates (tip_442.php)
Tip 474: Filter data in a PivotTable and PivotChart using Slicers (tip_474.php)


* Unless stated otherwise, these tips were written for Microsoft Office 2010.