The filtering in Google Spreadsheets seems to only offer text based solutions.

Is there any ability to filter cells by date ranges like any of the following:

  • Today
  • Yesterday
  • Last Week
  • Since 1/1/2015
  • Between 1/1/2015 - 2/1/2015

Here's an example of the filtering options on a column that contains dates:


A couple of workarounds would be to:

  1. Format the dates so that they were YYYY-MM-DD so they showed up in the right order.

  2. Use the =Filter() function like this:


    But that requires adding a new sheet and manually updating the filtered values.
    I'd much prefer a solution that uses the built in filter feature

  • I could have sworn they used to have this functionality. Commented May 31, 2015 at 22:10

1 Answer 1


UPDATE: Today Google added filtering conditions to Google Sheets.

At this time the filter feature of Google Sheet doesn't include date range filtering.

Filter you data - Docs editors help
Google Sheets: Do more with your data - Google Docs Blog

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.