Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • Count unique text values with criteria
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Offset in Excel
  • Convert text string to valid reference in Excel using Indirect function

Data Analysis Examples

  • How To Create Pareto Chart in Excel
  • How to create a Histogram in Excel
  • Create Scatter Chart in Excel
  • How to create running total in an Excel Table
  • Excel Line Chart

Data Validation Examples

  • Excel Data validation don’t exceed total
  • Excel Data validation with conditional list
  • Excel Data validation require unique number
  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days

Filter Data Based on Date in Excel

by

This example teaches you how to apply a date filter to only display records that meet certain criteria.

1. Click any single cell inside a data set.

2. On the Data tab, in the Sort & Filter group, click Filter.

Worked Example:   Number and Text Filters Examples in Excel

Arrows in the column headers appear.

3. Click the arrow next to Date.

4. Click on Select All to clear all the check boxes, click the + sign next to 2015, and click the check box next to January.

Worked Example:   Remove Duplicates Example in Excel

5. Click OK.

Result. Excel only displays the sales in 2015, in January.

6. Click the arrow next to Date.

7. Click on Select All to select all the check boxes.

8. Click Date Filters (this option is available because the Date column contains dates) and select Last Month from the list.

Worked Example:   Subtotal function in Excel

Result. Excel only displays the sales of last month.

Note: this date filter and many other date filters depend on today’s date.

Post navigation

Previous Post:

Use Data Form to input, edit and delete records in Excel

Next Post:

Number and Text Filters Examples in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count line breaks in cell in Excel worksheet
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • T function: Description, Usage, Syntax, Examples and Explanation
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • Extract most frequently occurring text in Excel
  • List holidays between two dates in Excel
  • How to calculate next scheduled event in Excel
  • How to calculate most recent day of week in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Basic timesheet formula with breaks in Excel
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles