How do you sort a list of dates into date order

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

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

"Tegwen" wrote:

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

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.


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

--

Dave Peterson