Clever Clogs tip # 719
27 October 2022


Filter dates by month or quarter (Microsoft Excel) *

This week's tip is inspired by a question I got during Tuesday's Tables and PivotTables training session at Corpus Christi College. (Thanks for the tip inspiration, Liza.)

We looked at how to filter dates by month and if you type, say, 10 in the Search box you get days as well as months.

OK, you could type Oct ...

... but did you ever spot these additional options?

Here's how:

  1. If necessary, turn on filtering. (CTRL + T, anyone?)
  2. Click on the drop-down arrow of the date's column header.
  3. Click Date Filters.
  4. Click or hover over All Dates in the Period and select the relevant month.

This can also be useful if you want to quickly find data in a particular quarter.

Related tips

  1. Filter dates by month: tip_505.php
  2. Quickly format and enable filtering of your data: = tip_429.php
  3. Save time entering dates: tip_442.php
  4. Fast filtering: tip_426.php

Last week's #CleverClogsTipTime on LinkedIn

  1. Information Overload Day


* Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016.