Date filtering in Excel Online

danl1988

New Member
Joined
Feb 8, 2018
Messages
12
I have a file used by our R&D teams to track time. This file is accessed by several people, and hosted online. Recently, one of our managers complained that date filtering doesn't work.

Lo and behold, if you open the file and select Date Filters --> This Week (for example, see image) the entries filter to this week's dates. This is the expected outcome. No problem.

But if you follow the exact same steps in the same file but opened in the web version of Excel, the filtering fails. Any filtering previously applied - for example, suppose I had previously filtered to a specific date, and now I am selecting This Week - gets removed, so the entire list of all entries for all dates becomes shown. But the new filtering fails, leaving me with the complete list of all entries, rather than a filtered-down list.

Any idea why this would happen?

Attempted fixes so far:
  • I have checked the number (date) formats. All appear to be formatted the same, including the same regional setting (English: Canada)
  • I have used Excel's text-to-columns feature in an attempt to catch any outlier entries. No such luck.
Thank you,

Daniel
 

Attachments

  • Screenshot 2022-10-12 135844.png
    Screenshot 2022-10-12 135844.png
    201.4 KB · Views: 3
Last edited:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

danl1988

New Member
Joined
Feb 8, 2018
Messages
12
A few other things potentially worth mentioning:
  • The date column here is not a value. It is a formula using the Workday function.
  • Filtering based on other columns (including those which contain formulas rather than values) seems to work fine. Only the date filter fails.
  • I have checked to ensure the filter is capturing all of the rows below (and no extra rows - just the right amount)
  • Attached image is what this looks like in web version.
 

Attachments

  • Capture.JPG
    Capture.JPG
    153.7 KB · Views: 3

Forum statistics

Threads
1,186,124
Messages
5,955,977
Members
438,230
Latest member
Meemaw2212

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top