=if(sum(countif(e3:w3,">"&today()+30),countif(e3:w3,"up"))=19,3,if(countif(e3:w3,"<="&today())>0,1,2))