I have a long datasheet and i would like to filter it by moving only data from january etc. into another sheet in the workbook.
I would also like a sheet to show data from today.
This is the formula I was trying to use but it is not working. Im not sure what I am doing wrong.
=query(IMPORTRANGE("1qjOk6EGslZUsjEkv3vxafFmKZQyeDFBsDCYmzWuoW6U","Reservation!a:ah")," where col10=today() ",1)
Can anyone help?
Bookmarks