Special Dates Filtering Options

Learn the various options when filtering dates in Excel

Filtering by date provides you with an expanded arsenal of options to organize data based on time periods.

When filtering dates you can see for example all of the events on your list that happened on a certain day or in a specific timeframe.

You can also find who is having an anniversary in the next few days or who is going to have a birthday in November.

Looking in the near present or future is not complicated at all. Control over weeks, months, days, and weekdays is at your fingertips.

The filter by date submenu provides a ton of options and once you know how to use it, you only need to decide what period of time you want to filter.