CODEWITHSUNDEEP
dateselectgoogle-sheets
Meng Moreno
Meng Moreno

Reputation: 21

QUERY Specific column based on current date in google sheets

Please my sample sheet below:

https://docs.google.com/spreadsheets/d/1eDBqzwsyakyP3RGWAdNKs76Ia7JOGFwjIl_czREU0s0/edit?usp=sharing

I would like to know if I can query / filter a table to show someone's schedule based on the current date (Please see cell A25), I want to be able to have that table update based on the current date. Please advise. Thank you in advance, I appreciate all the help that I am getting from this group.

Upvotes: 0

Views: 380

Answers (1)

player0
player0

Reputation: 1

try simple:

=FILTER(B2:9, B1:1=B25)

enter image description here

Upvotes: 1

Related Questions