Count ids within a timescale - duplicate ids with multiple visit dates

Hello, I wonder if anyone can help with a problem please, this is my first post.

I have a list of ids, and a list of visit dates, many of them are the same id but they have multiple visit dates.
I need a formula to count the number of ids that have had visits within a 2 week period of their previous visit for each week. I only need to count the id once even if they have had multiple visits before the week-ending date.
I've already calculated the number of days since the previous visit and calculated to show those with a visit less than 2 weeks apart but I am struggling to bring it all together, I have a feeling it's a combination of MAX and IF formulas but would very much appreciate any help!

I hope this makes sense, let me know if you have any questions.

Many thanks

Originally Posted by Glenn Kennedy

In L2, copied down:

=SUM(INDEX(($D$2:$D$38>=K2)*($D$2:$D$38<=K2+14)/COUNTIFS($D$2:$D$38,$D$2:$D$38&"",$A$2:$A$38,$A$2:$A$38&""),0))

In your expected results, you said the answer at L2 should have been 2. Why?

Thank you,
So I wanted to count only those where, in the visit closest to the report date (Column K) there had been a maximum of 2 weeks between this visit and the previous visit date. I had got 2 because i filtered on the column D (visit dates) to only show visits before 05/04/2020 and then summed Col G (col g indicates a 1 if the visit was within 2 weeks of the previous visit) for the 2 id's most recent visit dates on the 30/03/2020 and the 03/04/2020.

Perfect! Thank you so much for your help