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.
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.