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:
- 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-DDso they showed up in the right order.
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