Named Range
 

Date 1 2 3 4 5 6 7 8 ...ect..
Employee NameRecord * <-formula in every column with 1 digit result



*
=IF(ISNA(AND(takeoff<=G$86,takeoff=$G$86,$B87<"" )),"",IF(AND(takeoff<=G$86,takeoff=$G$86),"",IF(I SNA(VLOOKUP($B87&G$86&$F87,ReqOff,3,FALSE)),IF(ISO DD(G$84),IF(VLOOKUP(first_name,staff_data,FSOS+G$8 3,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSOS+G $83,FALSE)),IF(VLOOKUP(first_name,staff_data,FSES+ G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSE S+G$83,FALSE))),IF(VLOOKUP(first_name&G$86&$F87,Re qOff,4,FALSE)=0,"",VLOOKUP(first_name&G$86&$F87,Re qOff,4,FALSE)))))

G$86 = Date
G$83 = Week Number
$B87 = Current Shift

That is the formula I am using. Right now it is working relatively okay, it
tends to freak out when I edit it in 2007 while using compatability mode
97-2003.

So the question here is....how can I replace $G$86 with a named range that
will fill across the month. I really need to shorten some of the formula...I
think that will help.

Thanks alot for helping me

Scottie