Hey thanks a lot for the help i really appreciate it but the formula that i am really having issues with are the ones in the shift column of VISUAL PLAN it looks like everything is fine but when you change M30 in PLAN is when everything gets wierd. for example when M30[PLAN] is 5(Thursday),6(Friday), or 7(Saturday) everything goes haywire it either shows the wrong info or it says #n/a and when i trace the error and try to debug everything apears normal if you could take another look that would be wonderful i've spent 2 hours just on these formulas today and i just can't grasp it. Thanks a lot