Filter by date

To filter a range by date, follow these steps:

1.Define the sort and filter range.

2.Click the Sort and filter button in the upper cell of the column where you want to filter the data.

3.In the window that opens, select By condition filtering method.

4.In the drop-down list, select the condition to filter:

5.In the field below the drop-down list, enter the date or dates (for the Between condition) manually or click the button and select a date in the calendar. If you type an incorrect data entry, the field can be quickly cleared by clicking the button.
The following date input formats are supported for manual entry: “dd.mm.yyyy”; “dd.mm.yy”; “d.m.yy”; “dd month yyyy” (month can be entered in Russian only); “dd mmm yy” (for example, “mmm” = “ноя”); “mmm-yy”; “dd-mmm” (the current year will be used); “yy.mm.dd”; “yyyy.mm.dd”; “y.m.dd”; “y.m.d”; “y.mm.dd”; “dd month yy”; “yy mmm dd”; “dd mmm yyyy”; “mmm yyy”; “mmm-yyyy”; “mmm yyyy”; “yy mmm”; “yymmm”.

6.Click Apply.

The appearance of the sort and filter button may differ from the one shown here because it depends on whether sorting has been previously applied, the sort order (ascending or descending), and whether a filter has been previously applied:

–: No sorting or filtering applied.

–: Filter applied, no sorting applied.

–: Sorted in ascending order with no filter applied.

–: Sorted in descending order with no filter applied.

–: Sorted in ascending order with filter applied.

–: Sorted in descending order with filter applied.

To clear the filter applied to a column by date condition without resetting the sorting, follow this steps:

1.Click  Sort and filter.

2.In the window that opens, select By value filtering method.

3.Click Apply.

To clear the filter applied to a column by date condition along with sorting, do the following:

1.Click  Sort and filter.

2.In the window that appears, click Clear.