I might be completely overlooking the feature, but i've been trying to filter a range of dates to only display today and future days in Excel Online (365).
At first sight it appears that there is such a feature:
Data > Filter > Click array on column > Date Filters > ...
However, there is no default filter to display only today and future dates. There is one to do the exact opposite (Year To Day). So I guess it would be either custom filter.
In the next screen I can't seem to add a TODAY() function or anything at all. So definitely no TODAY()-1 or something.
Any suggestions anyone or is this just a feature that hasn't made it to Excel online..
Example sheet:
32 Answers
You can filter your dates in a table in Excel Online in same way as normal via Date Filters.
Apply a custom filter that uses the condition 'Is after or equal to' then the value of 'Today'
3You're right, it turns out it isn't obvious, and doesn't work quite the way we were all guessing. Here's how you can set the filter to "today and future dates".
Use the Filter pull-down (the little icon already showing in the "Date" column heading), and select After.
Thanks, Lee, for the image.
That will open a little dialog window prefilled with is greater than and an entry box.
Type yesterday's date in that box, and click OK.
Unfortunately, you can't insert functions like TODAY() or cell references, you can't use multiple selections from the initial list, like After and Yesterday, and picking one of the date offerings from the list automatically assigns = as the comparison.
