Hello dear Excel friends,
I've got one very strange column of dates, and since I'm still in very early stages of knowing and understanding Excel,
I can not really find a way to sort them from oldest to newest.
The dates in the column are in different formats and probably the first thing would be convert them into one format.
They are, like...
04/07/2014 04:50
and
08/24/12 09:46:59
... type cells. The next thing would be sort them in some logical way not just by first number.
Column with dates.xlsx
What I am having now and how far I am, is...
They might be sorted in some way by month and date but not by actual year that is left out completely.
It is just total mismatch and doesn't make any sense to me at all. Forget about time, that's not important at all.
I would gladly appreciate any help someone could give, and point me in the right direction.
Thanks a lot,
John
Bookmarks