I have another question, I have multiple sheets on each workbook and when I copy the formulas to the next sheet it only works to find max/min of hte month not of the weekends. I get the #Value error, and i hit Ctrl+Shift+Enter when I'm done. What do I need to change so that it is consist on each sheet?

I don't know where I'm supposed to put your 2 codes where you make the ranges? I just made my own ranges on each page by selecting each column and naming it.