How do you sort a list of dates into date order

T

Tegwen

When I do the above, it sorts it by the day only - I want it to be sorted by
day, month and year.
 
D

Duke Carey

If they are truly entered as dates then they will sort as you want them to.
Thus, it seems fair to assume you do NOT have them entered as dates.

Please provide an example of the cell contents for a few of these entries
 
D

Dave Peterson

You want the first of every month before the 2nd of any month???

You could a helper column filled with formulas:
=text(c1,"ddmmyyyy")
and drag down

and sort by that.


If you have a list of (say) birthdays and want to group them by day of the month
(disregarding year), you could use a formula like:

=text(c1,"mmddyyyy")
and drag down

and sort by that.
 
Top