Filter Question

[ryguylears]

I was hoping there is a way to filter by date if I have multiple dates in a cell. My most recent entries are on the top of the cell and I want to be able to filter by anything thats 20 days or older on the top line. See below for my entries.

11/1/21: Rev 1 bid submitted
10/22/21: Hard bid submitted
10/1/21: Budget submitted.

Thats what one cell looks like with multiple entries, and I want to be able to filter for anything that is older than 20 days based on the most recent entry the on the top line (in red).

Is this possible or would I have to have individual cells for each entry?

Thank you

 

[jasonb75]

Is this possible or would I have to have individual cells for each entry?

It may be possible but being realistic, it would be far from practical. Personally, I wouldn't even waste time attempting to make it work.

Stick to the rule 1 date 1 cell and everything will work fine. Make note that I specifically said 1 date 1 cell. There should be nothing else in that cell, only the date. Your example should populate 6 cells, 3 rows, 2 columns.

 

[ryguylears]

I figured but if i did this, it would make the sheet VERY lengthy and cumbersome as I have thousands of entries with multiple dates. Just looking for a quick fix solution

 

[jasonb75]

it would make the sheet VERY lengthy and cumbersome

Your existing way is making it cumbersome. There are no justifiable reasons for such a badly laid out data set.
As soon as you put something in a cell with a date, it is no longer a date, it can not be compared to a date, it can not be filtered as part of a date range.

If you're insistent on using such a bad layout then you could try using a formula in an adjacent column to attempt to convert the first part to a proper date, then filter on the formula column.
Assuming first cell with data is A2, edit as needed.

=DATEVALUE(LEFT(A2,SEARCH(":",A2)-1))