count unique dates based multiple criteria within given date range

[aceif]

I'm using the formula =ArrayFormula(SUM(--(FREQUENCY(IF(Data!A:A=D2,Data!B:B),Data!B:B)>0))) to count unique Dates in Column B if Column A matches the name in Column D however I'm struggling to refine the formula to only give me unique dates within the date range specified in F2 and G2

Name	Date		Name	No. of Shifts	From	Until
Anthony Brown	01/05/2015		Peter Gray	4	01/05/2015	27/05/2015
Anthony Brown	01/05/2015		Tim Sherwood	17
Anthony Brown	01/05/2015		Sachin Patel	16
Anthony Brown	01/05/2015		Anthony Brown	19
Anthony Brown	01/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	04/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015
Anthony Brown	05/05/2015

<tbody>
</tbody>

 

[BGY23]

Hi,
In column A put a blank column called count.
assuming your names and dates are in B and C with individual names in E. Reults in F and Dates in G and H.

Type this formula in A2 and copy down =IF(OR(B2<>B1,C2<>C1),1,0).

In F2 type this formula =SUM(IF($B$2:$B$60=$E2,IF($C$2:$C$60>=$G$2,IF($C$2:$C$60<=$H$2,$A$2:$A$60)))).

Its an array formula that requires you to press Ctrl, Shift and Enter Keys all at the same time. Done correctly you will see { and } at the start and end of the formula.

I have only used 60 rows to test it.Adjust the formula as required.

Good luck.

 

[Aladin Akyurek]

What are you requiring - a unique count of dates per name related to the From-Until interval?

 

[aceif]

Perfect, that's done the trick. You're a genius!!