Forum Discussion
LCS
Aug 25, 2022Copper Contributor
Need help with a excel formula which will show how many consecutive days within a week an EE worked
I need to identify how many days within a week an employee worked so we can flag anyone with more than 4 shifts per week. Im using date worked and the calendar week of the year to try and calculate ...
PeterBartholomew1
Aug 26, 2022Silver Contributor
This uses 365 for the spilt ranges but could be done without
= COUNTIFS(
EmpID, reportEmp#,
Week, reportWeek#)