Filter just dates from today +5 days

[matrixpom]

Hi All,

I have a spreadsheet with 2 columns titled "Shipping Date" (column 46) & "Date Shipped" (column 47). I'm trying to put a code together that will AutoFilter column 46, firstly remove all text or anything not in DD/MMM/YY format, & then filter dates from today plus 5, i have the code below but it just filters everything out on the last line? Is it because I haven't specified the date format? Any assistance as always will be greatly appreciated, thank you - Marco

Please Login or Register  to view this content.

[FDibbins]

Just so we are clear, columns are generally ID'd by letters (not numbers) a, b, c etc, and rows are ID'd by number - 1, 2, 3 etc

[matrixpom]

Hi FDibbins,

I've attached an example of my worksheet, I firstly need to filter out buildings that have been delivered (column AU), then filter all in column "AT" that are not in DD-MMM-YY date format e.g. all text or random numbers that are not clearly a date. Once this is done I need to filter all dates to show today + say 5 days. This will show me how many buildings I have to inspect for the week, hope that makes sense? Thanks for any help FDibbins, have a great day- Marco