I am tracking employees consecutive days worked. One cant work more than 13 consecutive days. Formula should count consecutive days worked, tough part is.... needs to reset count when employee doesn't work. Also, formula should base count on current date, which will change each day. Times in cells are clock in times, empty cells are days employee did not work. Hope I explained it ok.... I sincerely appreciate your patience and help. Thanks you.
10.5 KB Views: 16