Ok....here we go.

When using advanced filtering, I know you can search through text. And you can use wild-cards as well and all that.

My problem is I have text formatted like this:

Projected: 07-Dec-2004
0 Years 0 Months 7 Days

And I would like to be able to filter through cells like these for a range of dates (try swallowing that).

I know normally (with dated formats in the cells) it could be done with something like:

Start Date | End Date
>=1/1/2005 | <=2/1/2005

but this is definitely not the case here.

And I was ALMOST done, too


Any ideas?