Hi, I'm trying to figure out a formula that would give me the unique number of values in column A based on multiple criteria:

-A date range (greater than one day, less than one day) (Column B)
-A certain value in column C
-A certain value in column D

I've searched through many topics but haven't been able to quite find the answer I want. Any help is much appreciated!

Thanks!