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:
-
Format the dates so that they were
YYYY-MM-DD
so they showed up in the right order. -
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
Best Answer
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