Counting Unique Records Between Two Dates

[Moxioron]

Hello.

I am trying to count the number of days between two dates where an employee is logged in.

B8 = Employee Name
B3 = Start Date
C3 = End Date
Detail!$A$4$:$A$17000 = Range in which employee name would appear
Detail!$Q$4$:$Q$17000 = Range in which date would appear.

This is what I am attempting to use to obtain the count:
=SUM(IF((B8=Detail!$A$4:$A$17000)*(Detail!$Q$4:$Q$17000>=B3)*(Detail!$Q$4:$Q$17000<=C3))),1/COUNTIFS(Detail!$A$4:$A$17000,$B8,$A$4$:$A$17000,$A$4:$A$17000,Detail!$Q$4:$Q$17000,">="&$B$3,Detail!$Q$4:$Q$17000,"<="&$C$3))),0)

But I'm getting a "There's a problem with this formula" error message.

I know this is an Array formula and I am selecting Cntrl/Shift/Enter.

The Filter formula is not an option unfortunately. Where am I going wrong? Thank you.

 

[Eric W]

Try:

=SUM(SIGN(FREQUENCY(IF(Detail!$A$4:$A$17000=B8,IF(Detail!$Q$4:$Q$17000>=B3,IF(Detail!$Q$4:$Q$17000<=C3,Detail!$A$4:$Q$17000))),Detail!$Q$4:$Q$17000)))

with CSE.

 

[Moxioron]

Thanks so much .... that worked.

 

[Eric W]

Happy to help, thanks for the feedback. ?