Counting unique values with FREQUENCY, ISNUMBER, SEARCH, and MATCH - problem when adding date

[thomasuponor]

With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached

=SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole Olsen";J:J)))*(ISNUMBER(SEARCH(">=01-01-2020";D:D)))*(ISNUMBER(SEARCH("<=31-12-2020";D:D)));MATCH(F:F;F:F;0));ROW(F:F)-ROW(A3)+1)>0))

Thomas

 

[mart37]

Can you use XL2BB to post your data.

 

[mart37]

(ISNUMBER(SEARCH(">=01-01-2020";D:D)) --> (D:D>=DATE(2021;1;1))