Sorting Dates as Numbers

  • Thread starter Thread starter Scotty McExcellent
  • Start date Start date
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?
 
Hi

You could use a helper column alongside your data with this in:
=TEXT(A2,"dd/mm")
which you can then fill down.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to make the date format uniform ? 1
Changing date to eliminate day in format mm/dd/yyyy 1
Date Formats 1
Convert dates stored as text 2
date 1
Formatting Dates from Text to Numbers 2
reformat dates to yyyy/mm/dd 5
Date Format 2

Back
Top