I have this formula as a conditional format that highlights certain cells that meet the date requirements. I just want to add an extra criteria that highlights as well if the date=today. Seems simple but I cannot get the syntax right.
can anyone help?
can anyone help?
Excel Formula:
=AND(ISNUMBER(SEARCH("Condo",K11)),OR(AND(WEEKDAY(TODAY())>= 3,WEEKDAY(TODAY())<=6,INT(X11)=INT(TODAY()-1)),AND(WEEKDAY(TODAY())=2,INT(X11)>=INT(TODAY()-3),INT(X11)<=INT(TODAY()-1))))