Sorting dates

[David French]

I have a list of names and their DOB in DD/MM/YYYY format.
There is a Help topic which says to go to custom sort order and choose one
of the samples to sort in, say, MONTH order.

Is there a way to sort this list of dates by month WITHOUT separating the
DD...MM...YYYY into separate columns??

Dave French

 

[Earl Kiosterud]

David,

You don't have to separate them, but you'll need a helper column on which to
sort, if you want them ordered by month. This presumes you want all the
January's of various years together, etc.

=MONTH(A2) copied down.

This will give you 1 for Jan, etc. Sort the table on that column. You can
hide the column, and make a macro that sorts on it. this only works if
they're true dates, not text. If they're text, it'll take a different
solution.