I'm trying to create a Spreadsheet for work purposes but I can't get it the way I want. If I do it in Excel it works but I can't match it in Google Spreadsheet. I don't even know if it's possible. (See pictures below.)

When I filter in Excel, it breaks it down as "2016", "2015", etc. Each year I can click and they have the months in those years. Can this be done in Google Sheets?

Google Spreadsheet: Google Spreadsheet

Excel (how I want it): Excel


The filter in Google Sheets does not have this sort of tree selector for dates. Some alternatives:

  1. To display only the records from a particular year, select "Filter by condition" -> "Text ends with" -> 2014 (or some other year).
  2. To display only records within some period, select "Filter by condition" -> "Is between" -> start date, end date (for example, 5/1/15 and 5/31/15).

There are also some built-in conditions under Date is... such as "in the past month", "in the past year", etc.

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.