Filter by date

To filter a range of cells containing dates based on a condition, follow these steps:

1.Create a range of filtering with data of the Date type.

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

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

4.In the Condition by date drop-down list, select a condition for filtering:

5.In the box under the drop-down list, either type the date manually or click the button and select a date from 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.