Fix recent update. Filtering a date column no longer works!
The filter function for a column of dates has stopped working with a recent Excel for Mac 2016 update. Tip/clue: if you delete one of the dates in the column, the filtering again works as normal & expected.
I am having this issue as well. Please fix asap!!
Same. crazy. PLEASE FIX MS!!
Mai Hiếu Dưng commented
Me too! I'm so tired. If you add a cell with any type data, filter will working.