Filter the first criteria on the filter drop down list

[mazamizo567]

I want a code to tell the excel to filter the first criteria on the filter drop down list whatever this criteria is.

My request is to filter the first criteria but this criteria is variable

it changes everyday but its always the first

for example today the first criteria for filtering is 19-02-2021
tomorrow the first criteria will be 20-02-2021,after tomorrow will be 21-02-2021 and so on

thanks

[sintek]

You don't give much information...

today the first criteria for filtering is 19-02-2021
tomorrow the first criteria will be 20-02-2021,after tomorrow will be 21-02-2021 and so on

You do say today criteria is 19th tomorrow is 20th...TODAY is actually 21st so I am assuming you are always going to filter today's date less two days...
And as your sample file only has one date column ... Col A
This works...

Please Login or Register  to view this content.