With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, April 17, 2018
yogi_Sort A Column Of Dates In M/D/YYYY Style By Day In Ascending Order
My sheet keeps sorting the column by month, instead of mm/dd/yyyy. For example:
I want it in chronological order by date, not by the first number. I cannot share the spreadsheet, but here is my formula:
=query(importrange("link","Sheet1!A:AS"),"select Col4, Col18, Col19, Col20, Col21, Col22, Col25, Col26, Col27, Col39 where Col18 contains '1' or Col20 contains '1' or Col21 contains '1' or Col22 contains '1' order by Col39 asc format Col39 'mm/dd/yyyy'",0)