Forum Discussion
How to make the format of date from 1/1/2022 to 2022/1/1?
It looks like you have texts in column A, not dates. If so, you may convert them to dates by selecting column A, Data->Text to Columns, on third step of the wizard select Date and MDY.
Harun24HR Thanks for your promptly reply. In fact, I would like to sort the A column by date but it can't distinguish that 11 (Nov.) is more than 5, 4 and others. Do you have any comments on this. thanks.
SusanHung Because TEXT() function return string data as text. So you can sort then. You can try SORT() function then use text like
=TEXT(SORT(A1:A8,,-1),"YYYY/MM/DD")
I'm not sure if I'm missing any data processing. I couldn't get the date sorting as C column. I listed what i need as the C column (by manual). Thanks for your comments.
It looks like you have texts in column A, not dates. If so, you may convert them to dates by selecting column A, Data->Text to Columns, on third step of the wizard select Date and MDY.
SergeiBaklan Thanks for your comments. Great to learn.