Hi guys,
I have a column with dates. But I need them in backward order.
The format of the cells (the whole column) is text and it should remain that, so to change the format of the cell is not an option.
What formula can cause the following result?
'A' column is the original, 'B' column is the desired one.
A
A B 1 2016-10-10 10-10-2016 2 2016-10-10 10-10-2016 3 2016-10-11 11-10-2016 4 2016-10-12 12-10-2016 5 2016-10-12 12-10-2016 6 2016-10-12 12-10-2016
And so on...
Thank you all!
Bookmarks