How to Filter Date by macro?

Help Activities
, ,
1

I have 2 variable (date1 as sting , date2 as sting) Format dd/MM/yyyy

I want to filter column Due Date by condition data in column Due Date < variable date1 and delete rows >= variable date1 .
data filter2.xlsx (36.7 KB)

Example variable date1 05/06/2021 (string) , variable date2 03/06/2021

I want to filter in sheet Cash and show rows by column Due Date < 05/06/2021
and filter in sheet Chq and show rows by column Due Date < 03/06/2021

Please guide me about it.

2

@fairymemay - please refer this post