I have a 90 day tracker for employees hours. The only thing this tracker is concerned with is to make sure employees don't work over a specified number of hours within a revolving 90 day period. I have a summary page with 90 days starting with =today() and scrolls down to =today()-90. (it actually goes =a2-1, =a3-1, ect...) i have a details sheet that has employees numbered 1-45 along row1, employee names along row 2, and non revolving dates in column A ranging from april 07 - dec 07. using the formula on my summary sheet starting in cell B2:
=IF(ISERROR(VLOOKUP($A2,Details!$A$2:$AT$92,Details!B$1+1,FALSE)),"",(VLOOKUP($A2,Details!$A$2:$AT$92,Details!B$1+1,FALSE)))
The formula respectivly coinsides with each cell for the whole 45 columns and 92 rows
this keeps the number of hours worked per day sticking with the daily changing dates. It works great, except it wont accept new entries. when the date changes, it rolls the dates and hours like its supposed to, but it appears the formula is doing nothing for the =today() row and every new day after the orginal spreadsheet was made. Hope i explained that good enough. any ideas on how to make it accept new entries?
=IF(ISERROR(VLOOKUP($A2,Details!$A$2:$AT$92,Details!B$1+1,FALSE)),"",(VLOOKUP($A2,Details!$A$2:$AT$92,Details!B$1+1,FALSE)))
The formula respectivly coinsides with each cell for the whole 45 columns and 92 rows
this keeps the number of hours worked per day sticking with the daily changing dates. It works great, except it wont accept new entries. when the date changes, it rolls the dates and hours like its supposed to, but it appears the formula is doing nothing for the =today() row and every new day after the orginal spreadsheet was made. Hope i explained that good enough. any ideas on how to make it accept new entries?