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.