Hello -

I am working on a spreadsheet involving construction dates, and a number of the cells in the date column are written as 'In Progress'. Is there any way to be able to filter for dates after a certain year and not filter out the text-only cells? For example, if I want to show rows where the date is after 2005, this should include any cells with 'In Progress' since those projects will be constructed after 2005, but the way excel is set up now it automatically excludes cells that contain any text from any sort of date filtering I've tried.

I know the basics of VBA if it's possible to set it up that way.

Thanks!