Timesheet Example.xlsx
I'm working with a timesheet workbook where employees enter their hours biweekly. However due to an oddity between two departments, the way that the hours are recorded and the way that HR pays the employees the weeks don't line up. For example hours are recorded for management purposes from 10/29-11/9 but the pay period is calculated as hours from 11/1-11/15 (it's really dumb, I know).
So I basically want to use SUMIFS except as far as I can tell you can't use an operator like >= with are variable with SUMIFS.
So I want a way to sum the numbers in one column (the total hours worked for a day) that fall within a range of another column (begin date of a period and end date of a period).
I feel like I've gotten really close with a couple of tries but I keep coming up short. Any advice?
Bookmarks