Filter by Month in Excel: Step-by-Step

Formulas & functions · Updated November 20, 2026

To filter Excel dates to one particular month and year, open the date column’s filter menu and choose Date Filters > Between, then enter the first and last dates of that month. To show the same month across multiple years, add a helper column with =MONTH(A2) and filter it to the month number. Start with a column of real Excel dates and a clear header; the method you choose depends on whether the year matters.

What You’ll Need

  • A worksheet with dates in one column, ideally with one header row and no blank rows splitting the data.
  • Dates stored as Excel date values, not text that only looks like a date. Click a cell and check whether changing its number format changes how the value appears.
  • Microsoft Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac and Excel for the web have similar filter options, though menus and shortcuts can differ slightly.
  • If you want the same month across different years, an empty column for a month helper field.

Step-by-Step

  1. Check and organize the date column. Make sure each row represents one record and the date column has a descriptive header, such as Order Date. Remove merged cells and avoid blank rows inside the data range. If you have dates mixed with notes or text in the same column, move or correct those entries first; Excel may not offer date-specific filter options when it cannot recognize the column consistently. A date’s display format can vary, but the underlying cell value must be a date for the date filters to work reliably.
  2. Turn on the filter controls. Click any cell in the data range. On the ribbon, select Data > Filter. Excel adds a dropdown arrow to each header in the contiguous data range. On Windows, Ctrl+Shift+L toggles filters on or off. On Mac, use Data > Filter if the keyboard shortcut differs on your setup. If the data is already an Excel table, filter arrows are usually present; click the date column’s arrow to continue.
  3. Choose whether you need a month-year or a month across years. This is the key decision. For example, filtering for March 2025 means keeping dates from that year and month only. Filtering for March regardless of year means keeping March 2023, March 2024, March 2025, and so on. A date filter for a single month and year is simplest for a one-time report; a helper column is clearer when you need to repeat a month-only filter or compare that month across years.
  4. Filter for one specific month and year. Open the dropdown on the date column, point to Date Filters, and choose Between. In the dialog, enter the first date of the month as the lower limit and its last date as the upper limit. For March 2025, use March 1, 2025, and March 31, 2025. Confirm that the filter is set to include dates between those limits, then select OK. Excel hides rows outside the range; it does not delete them. If your version presents a date hierarchy under All Dates in the Period, you can also expand the relevant year and select the month there. Check that the year is correct before applying it.
  5. Filter the same month across all years with a helper column. Add a header such as Month Number beside the date column. With dates in A2:A1000 and the helper header in B1, enter this in B2: =MONTH(A2). The formula returns 1 for January, 2 for February, and 12 for December. Fill it down through the rows of your data. If the first date is March 14, 2025, the result is 3. Open the helper column’s filter arrow and select only the number for the month you want. Because the year is not part of this helper value, the filter keeps that month in every year represented in the records.
  6. Use month names instead of numbers if that is easier to read. With actual dates in A2:A1000 and a helper column starting in B2, you can use =TEXT(A2,"mmmm"). This returns a name such as March, which you can select from the helper column filter. Fill the formula down as above. The month number method is usually more robust for sorting, because text month names sort alphabetically rather than in calendar order. Both methods group matching months from different years together, so they do not identify a unique month-year by themselves.
  7. Check the visible rows and clear the filter when finished. Look at the date values and, if relevant, the years to make sure the results match the intended month. To show all rows again, open the column dropdown and choose Clear Filter From followed by the column name. You can also go to Data > Clear to clear active filters. Clearing a filter reveals hidden rows; it does not remove helper formulas or change the stored dates.

For a dataset you filter often, consider converting the range to a table: select a cell in the data and choose Insert > Table, then confirm that the table has headers. Tables keep filter controls attached as you add rows, and a helper-column formula generally fills into new table rows automatically. Check the table’s date filter after adding records so you know the new dates are included.

Common Mistakes

  • Filtering by month name when the year matters. A helper value of March or 3 groups every March together. Use the date column’s date-range filter, or include the year as a separate condition, when you need only March of a particular year.
  • Using text that resembles a date. Values imported from a CSV or copied from a website may be text. Excel may then show text sorting options rather than date filters, or sort dates alphabetically. Convert the values to real dates before filtering; changing the cell’s display format alone does not convert text into dates.
  • Filtering the wrong range. A blank row or column can cause Excel to treat part of the data as a separate region. Click inside the records and check that the filter arrows appear on every intended header. Remove unintended gaps or convert the full range into a table.
  • Forgetting that another filter is already active. A month filter can be correct while an existing filter on a different column hides some matching rows. Check for filter indicators in other headers, or use Data > Clear and apply the filters again.
  • Entering the wrong date limits. Confirm the year and the number of days in the month. April, June, September, and November have 30 days; February has 28 or 29. If your records contain times as well as dates, read the troubleshooting guidance below before relying on an inclusive end-date limit.

Tips

  • Use a recognizable date format such as 14-Mar-2025 while checking the source data. This can make month and year errors easier to spot than an ambiguous format such as 03/04/2025.
  • Keep helper columns in the table rather than placing them far away from the records. Give the column a clear name, such as Month Number, and hide it only if users do not need to see it; hiding does not stop its filter from affecting the results.
  • For a month-year report you run repeatedly, add a Year helper as well as a Month Number helper. Filter both columns together, for example Year = 2025 and Month Number = 3. This is explicit and avoids confusing March from different years.
  • Use the date column’s dropdown to inspect available date groups. Depending on the data and Excel version, the list may be grouped into years, quarters, and months. Expand the year you need instead of assuming a month selection covers only one year.
  • When working in Excel for the web, use the filter arrows and date filter choices in the same way where available. The interface can look different from the Windows desktop ribbon, so rely on the option names shown in the dropdown rather than a particular screen position.

Troubleshooting

Date Filters is missing or the menu offers only text filters: Excel may be treating some or all entries as text. Test a few cells by changing their number format to General or Short Date. If the displayed values do not behave like dates, convert the source values using Data > Text to Columns where appropriate, or re-import the data with the correct date locale. Confirm that the month/day order in the source matches your regional settings before converting; 04/05/2025 can mean different dates in different locales.

The filter returns no rows: Check that the dates actually fall within the year and month entered, then clear other active filters. Also verify that the date limits were entered as dates rather than as text. If you used a helper column, confirm that the formula was filled down beside every record and that the selected month number is correct.

Rows on the last day are missing: Some datasets contain timestamps, such as March 31 at 3:00 PM, rather than dates set to midnight. A limit entered as March 31 may not include every time on that day in every filtering setup. For timestamp data, use a helper month field to group by month, or filter using a range that ends before the first day of the following month and account for the time component. Check a known record at the end of the month to confirm the result.

New records do not appear in the filter: The filter range may not include rows appended below the original data. Convert the range to a table, or turn the filter off and select the complete expanded range before choosing Data > Filter again. If the helper formula is not present in new rows, fill it down or let the table’s calculated column populate it.

Month names are out of calendar order: This is expected when filtering or sorting a text helper column; April sorts before August alphabetically. Use a month-number helper for calendar ordering, or keep the original date column and sort that column by oldest to newest.

Frequently Asked Questions

Can I filter for January from every year?
Yes. Add a Month Number helper using =MONTH(A2), fill it down, and filter that helper to 1. The date column must contain real Excel dates. If you instead want January in one particular year, use the date range for that month or filter by both year and month.

Can I filter by month without adding a helper column?
Yes, for a particular year and month, use the date column’s Date Filters > Between option and enter that month’s first and last dates. A helper is a straightforward way to select one calendar month across several years.

Will filtering by month delete or change other rows?
No. A filter hides rows that do not match; it does not delete them or change their values. Use the dropdown’s clear-filter option or Data > Clear to display the full dataset again.

Why does Excel show a list of years and months instead of Date Filters?
Excel may be showing a grouped date checklist, or your particular version may present date choices differently. Expand the year and select the month if you need that specific period. If the menu has no date options at all, check whether the source values are real dates rather than text.

Can I filter by month in Excel for Mac or the web?
Yes. Excel for Mac and Excel for the web support filtering date columns, though the ribbon layout and dropdown appearance can differ from Microsoft 365 for Windows. Use the date column’s filter menu and look for date-range or grouped-period choices. If the needed grouping is not available in the menu, a Month Number helper column works across versions.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.