Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface

Add to Favorites
Author: | Edits: don

Learn to make a beautiful and intuitive date filtering interface for your data in Excel that allows you to quickly view data for custom date periods, including rolling date periods, like This Month, Last Month, This Year, Last Year, or any other date interval that you can think of - I show you how to make the system that you need to view any custom date period that you can formulate.

This technique combines many features, including Tables, Data Validation Drop Down Lists, Custom Date Formulas, Lookups, FILTER() function for new versions of Excel, a crazy formula for older versions of Excel, and even rounded corners to make everything look nice.

The goal of this tutorial is to make it easier and nicer for you to analyze sets of data, particularly raw imported data - this works for stock data, financial transactions, bank records, sales data, or any kind of data that includes a date column.

I take you from processing the raw data, so it will filter better, all the way to making custom date formulas and polishing the front-end interface so that it looks nice and is easy-to-use.

Additional Resources

Excel Function: FILTER(), IF(), IFERROR(), INDEX(), ROW()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.