Cell G7 should show the time in HH : MM : SS until the US stock market is next open.
Cell G4 calculates either OPEN or CLOSED depending on if the VLOOKUP that searches the sheet ALGORITHM for either FALSE of TRUE for if each day the market is open (weekends are marked as FALSE as are any holidays) AND if the current time (found within cell B10)falls within market hours which are displayed at K6 and M6.
Current formulas:
G7 : =IF(G4="OPEN",M6-B10,K6-B10)
G4 : =IF(AND(VLOOKUP(B4,ALGORITHM!D5:ALGORITHM!J369,5,),B10>=K$6,B10<M$6),"OPEN","CLOSED")
Could anyone suggest a potential formula or VBA solution for this?
