Date filtering

[logisticsexcel]

Hi,

I want to filter dates based on set criteria.

Criteria is leave today's date and all other NA dates(01/01/1900) unfiltered. Rest all filter out.

I have attached an example with before and after filtering.

Can it be done with VBA?

Thanks

[ikboy]

try this:

Please Login or Register  to view this content.

[logisticsexcel]

Hi ikboy,

The code works. Can you please tell me how do I apply the code if I have data from column A to V and the column to apply filter is V.

Thanks

[ikboy]

try this:

Please Login or Register  to view this content.