I am trying to find if same id numbers has an overlap in dates and I got the following. Can you please tell me where I went wrong?
With ws
Dim LR As Long, _
DateFrom As Range, _
DateThru As Range, _
EIN As Range
LR = Range("A" & Rows.Count).End(xlUp).Row
Set DateFrom = Range("J2:K" & LR)
Set DateThru = Range("K2:J" & LR)
Set EIN = Range("B2:B" & LR)
Range("L2").Forumla = "=SUMPRODUCT((RC[-2]<=" & DateThru.Address & ")*(RC[-1]>=" & DateFrom.Address & ")*(RC[-11]=" & EIN.Address & "))>1"
End With