i have list of events , dates. can use below formula today's (well sort-of incorrectly filtering date) information.
=query(a:b, "select * todate(a) = todate(now())") now show events entire upcoming week below formula, though might work, doesn't
=query(a:b, "select * todate(a) = todate(now())+1")
with query:
=query(a:b,"select * >= date '"&text(today(),"yyyy-mm-dd")&"' , a<=date '"&text(today()+7,"yyyy-mm-dd")&"' ") but 1 of = should excluded, depending on 7 days required.
