Answer the question
In order to leave comments, you need to log in
How to change date format when querying QUERY in Google Sheet?
The task is to display a column with the name of the month in Google sheets. Simple formatting is not suitable, because the lines are added through a google form. In this case, the set format flies / overwrites. For the same reason, you cannot immediately write formulas in cells. I found a solution for displaying the date through a QUERY query
=QUERY(A:J;"select B";1)
, where column B is the date of the format "03/10/2021" and the title in the first line
. As a result, you need to get the date of the "MMM" format, i.e. "mar."
I know that you can use the format function in the request, but according to the available examples and descriptions, I still don’t understand how to use it.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question