Sorting Dates as Numbers

S

Scotty McExcellent

I have converted dates in a dd/mm/yyyy format to a dd/mm format. Now
I want to sort by these dates so that I have all the 01 bdays then 02,
etc. However, Excel still remembers the year, so it sorts them by
that. Is there a way to convert dd/mm/yyyy to dd/mm and then sort by
that?
 
G

Guest

Hi

You could use a helper column alongside your data with this in:
=TEXT(A2,"dd/mm")
which you can then fill down.
 
B

Bob Phillips

Presumably it is just formatted as dd/mm? If so, you need to create helper
columns with the month (=MONTH(A1)), and day (=DAY(A1)) and sort by those
extra columns.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top