Hey guys,

I made the following formula on Google Sheets: =LOOKUP(WEEKDAY(J2),B1:H1,B2:H2)

Where J2 has the =Today() function, B1:H1 tells the function what day of the week it holds and B2:H2 what its operating hours.

I am looking to use the lookcup function on Airtable, and depending on =today() date find out from the spreadsheet a respective operating hour of a certain restaurant.

Thanks.