I have a question, how to apply date format to the results comming from query(Importrange) formula.
My formula "=filter({A:A,row(A:A)},isnumber(A:A))" in B1 can't see these dates. Spreadsheet only can see this as a text, not number.
I have a question, how to apply date format to the results comming from query(Importrange) formula.
My formula "=filter({A:A,row(A:A)},isnumber(A:A))" in B1 can't see these dates. Spreadsheet only can see this as a text, not number.