Filter Date Columns

[bknight]

I have an issue with filtering date column rows. I have set the filter to say m/dd/yy and all dates listed, so I changed the filter to mm/dd/yyyy and all dates are listed. As a final step I inserted # before and after like Access and all dates are listed. So what is the proper entry to obtain a filtered list of dates i.e. 5/27/2021?

[bknight]

Additionally there is a summation row=2 and two completely blank rows=3,4. The summation row is filtered out and the blank rows are not.

[HansV]

One way to do this:
- Click the Filter dropdown.
- Clear the check box 'Select All'. Now nothing is selected.
- If necessary, expand 2021, then expand May.

S0457.png

- Scroll down, and tick the check box for 27.

S0458.png

- Click OK.

[bknight]

You may have to go back one or more generations as I am using 2007. I should have included that in the original post, sorry.

[bknight]

I just tried another similar workbook/worksheet and the filter process works as expected.

[HansV]

Did you click in the data and then click Filter in the Sort & Filter group of the Home tab of the ribbon? That will add a filter dropdown arrow to each of the column headings.
For a date column, the options shown in my previous reply are available in Excel 2007 too.

[bknight]

I'm not sure what you mean exactly, but here are some images. You did see that the filter functions work properly in another similar instance?

[StuartR]

Is the date definitely dates, or could it be text that just looks like dates?

[bknight]

Look at the first image with the date selected. BTW I tried filtering on "5/27/2021", that didn't work either. I refer back to the post of 08:21 my time.

[HansV]

Since there are blank rows below the column headers, the filters don't "see" the data.
Do the following:
1) Select cell A1.
2) Click Filter in the Sort & Filter group to turn the filter OFF.
3) Select the entire range in columns A to O from row 1 to the last used row.
4) Click Filter in the Sort & Filter group to turn the filter ON again.
5) Click the filter arrow in one of the date columns.

[bknight]

Here is a similar worksheet.
The images are too large for the site and the filtered results will be in the next post.

[bknight]

Here is the filtered results. As I indicated this worksheet behaves in the manner expected. There are blank rows in this spreadsheet also, but I will attempt to follow your suggestions Hans.

[bknight]

Yes Hans the filter process worked with your suggestion, that doesn't explain the different result in two similar spreadsheets.
Thanks Hans.

[HansV]

The most probable explanation is that the whole range was NOT included when the filter was turned on in the "problem" worksheet, while it was included in the worksheet where it worked as intended.

[bknight]

Using that thought, I deleted the filter then selected Columns A-O and then reapplied the filter to the top row as before resulting in an expected behavior, thank Hans.

[HansV]