I have a data set where 1 of the columns contains dates in "YYYY-MM-DD" format. I'd like to use a single query formula to select some columns from that data set, including the date column. That's not an issue, however I'd also like to use the same/one formula to add an extra column to the output converting the existing date format into "Long month, Year" format. Preferably this can be done so that the final column is not a TEXT format.
I have this sheet containing the sample data set, small sample of what I tried, and the desired output https://docs.google.com/spreadsheets/d/1MdeiGKQduOWeCYUrioi_THl3VgNw4jciE28qzklynP8/edit?usp=sharing
Appreciate the help