There are three columns A, B, C AND today date is in the first row of the column A means A1. I need to import these three columns date excluding date row. A2:A100, B2:B100, C2:C100 in another sheet.
I have tried this:
=filter((importrange("sheets key", sheet1!A:F), importrange("sheets key"sheet2!A2:C10 =TODAY()))
My formula got an error cannot solve this.