@fairymemay - Here you go DateFilter_Noona.zip (107.9 KB)
Currently I have the input date of 22/05/2021 so you see 4 rows filetered, and if you change the date to 20 you will see no rows. Please do delete the Output sheet try both the dates
Once you understood what is happening, Repeat the process for CaseCH sheet by yourself.