days worked

I have a workbook that takes data from one program, tracks the hours of all the employees, and produces an upload file for another program (accounting software) that processes payroll. As these employees work multiple jobs a weeks, sometimes even multiple in one day, I need to count the days...

I’m interested in a few formulas to calculate total number of days worked and days off in a calendar year, and each month based on known values. For example: Employee Day Rate: $500/day If they work a schedule that is 3 days on and 4 days off that repeats itself for a year, I would like to...

I need to track what days a person worked and the if they work 7 or more days in a row have it highlight those days ( say if I worked 9 days in row those cells would change to Red). I will tracking this for a full year. The formula I started using was...