Hi,

I am using 
=MAX(IF(C25:O25>=Summary!C3,IF(C25:O25<=EOMONTH(Summary!C3,0),C28:O28)))
which works when everthing points to the same sheet.

I am trying to change C28:O28 to another sheet, sheet1 but cant get it to work?!?!

Kevin