2

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:

screenshot

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:

    =FILTER(A:C,A:A>=TODAY(),A:A<=TODAY())
    

    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. – camdenl May 31 '15 at 22:10
2

UPDATE: Today Google added filtering conditions to Google Sheets.

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

References
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, privacy policy and cookie policy

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