Hey Roy!

Sorting/filtering is being blocked by the one big merged cell in Column A.  Once you un-merge, or just delete column A, you can sort to your heart's content!

Cheers,

Jerry

Hi Gerald

What I need to do is filter/search events by month. The information I have includes other information along with the date. I cant figure out how to filter by date alone. Any ideas?

Thank You!

Roy -

As a mixed text field, I think you will find it difficult to accomplish your queries without some level of manipulation.

Here's a quick method with a helper column you could then sort on:

Insert a column to the right of your Event Info column.  Use this (or similar) formula to extract the date info:  =IFERROR(LEFT(I2,10)+0,"")

Format the new column as Short Date, and you should be able to search and sort. 

This should work based on your current data structure. 

If you will be updating/refreshing the sheet frequently, consider using Power Query to capture those steps as a repeatable process.

Your sheet attached with the mods.

Cheers,

Jerry

Hi Roy

Just like what Jerry said, you will have to delete column A and create a helper column

You can try this formula since your dates are in US format.

=IF(ISNUMBER(LEFT(H2,1)+0),DATE(RIGHT(LEFT(H2,10),4),LEFT(LEFT(H2,10),2),MID(LEFT(H2,10),4,2)),"")

Format it accordingly.

Sunny Kow