in a1 CHOOSE(WEEKDAY(TODAY()),"Sunday","MONDAY","TUESDAY","WEDNSDAY","THURSDAY","FRIDAY","SATURDAY")

in b1 time 07:30

in C1 =IF(AND(B1>= OFFSET(B1,MATCH(A1,A2:A8,0),0),B1<= OFFSET(B1,MATCH(A1,A2:A8,0),1)),"Open","Closed")


in A2 to a8 mon to sat all uper case like "MONDAY"
IN B2 TO B8 OPENING HOURS
IN C2 TO C8 CLOSING TIMES