Microsoft related doc:

• https://support.office.com/en-us/article/Filter-a-list-of-data-in-Excel-2016-for-Mac-fb78371e-bf7e-4945-acc7-b93726985cd8

For filter options, please refer to attached screenshots.

This feature doesn't include ZSS-1194 Display date values in a tree hierarchy inside a filter