Feb 07 2022 01:16 PM
Feb 07 2022 02:13 PM
=COUNT(UNIQUE(FILTER(B2:B27,(C2:C27>=H2)+(C2:C27<=I2))))
Is this what you are looking for? The formula returns the number of unique device id numbers 12 weeks before and 12 weeks after a certain date as shown in the attached file.
Feb 08 2022 12:23 PM